Invitation |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Invitation |
Logical Rolename | |
ColumnName | INVIT |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Invitation Logical Attribute Properties |
Logical Attribute Name | Invitation |
Datatype | VARCHAR(4000) |
Nullable | YES |
Invitation Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Invitation Security Types |
Name | Current Value |
Invitation Bound Attachments |
Name | Current Value |
Invitation Data Movement Rules |
Name | Type | Rule Text/Value |
Invitation Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Invitation |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF INVIT |
NO |
Invitation Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Invitation Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Invitation Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Invitation Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Purpose |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Purpose |
Logical Rolename | |
ColumnName | PURPOSE |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Purpose Logical Attribute Properties |
Logical Attribute Name | Purpose |
Datatype | VARCHAR(4000) |
Nullable | YES |
Purpose Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Purpose Security Types |
Name | Current Value |
Purpose Bound Attachments |
Name | Current Value |
Purpose Data Movement Rules |
Name | Type | Rule Text/Value |
Purpose Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Purpose |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF PURPOSE |
NO |
Purpose Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Purpose Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Purpose Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Purpose Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mission |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Mission |
Logical Rolename | |
ColumnName | MISSION |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Mission Logical Attribute Properties |
Logical Attribute Name | Mission |
Datatype | VARCHAR(4000) |
Nullable | YES |
Mission Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Mission Security Types |
Name | Current Value |
Mission Bound Attachments |
Name | Current Value |
Mission Data Movement Rules |
Name | Type | Rule Text/Value |
Mission Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Mission |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF MISSION |
NO |
Mission Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mission Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mission Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mission Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Charge Number |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Charge Number |
Logical Rolename | |
ColumnName | CHARGE_NBR |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Charge Number Logical Attribute Properties |
Logical Attribute Name | Charge Number |
Datatype | VARCHAR(4000) |
Nullable | YES |
Charge Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Charge Number Security Types |
Name | Current Value |
Charge Number Bound Attachments |
Name | Current Value |
Charge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Charge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Charge Number |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF CHARGE_NBR |
NO |
Charge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Charge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Charge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Charge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Subject Code |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Subject Code |
Logical Rolename | |
ColumnName | SUBJ_CD |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Subject Code Logical Attribute Properties |
Logical Attribute Name | Subject Code |
Datatype | VARCHAR(4000) |
Nullable | YES |
Subject Code Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Subject Code Security Types |
Name | Current Value |
Subject Code Bound Attachments |
Name | Current Value |
Subject Code Data Movement Rules |
Name | Type | Rule Text/Value |
Subject Code Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Subject Code |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF SUBJ_CD |
NO |
Subject Code Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Subject Code Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Subject Code Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Subject Code Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Initiator |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Initiator |
Logical Rolename | |
ColumnName | INITIATOR |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Initiator Logical Attribute Properties |
Logical Attribute Name | Initiator |
Datatype | VARCHAR(4000) |
Nullable | YES |
Initiator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Initiator Security Types |
Name | Current Value |
Initiator Bound Attachments |
Name | Current Value |
Initiator Data Movement Rules |
Name | Type | Rule Text/Value |
Initiator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Initiator |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF INITIATOR |
NO |
Initiator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Initiator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Initiator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Initiator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Onsite Access |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Onsite Access |
Logical Rolename | |
ColumnName | ONSITE_ACC |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Onsite Access Logical Attribute Properties |
Logical Attribute Name | Onsite Access |
Datatype | VARCHAR(4000) |
Nullable | YES |
Onsite Access Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Onsite Access Security Types |
Name | Current Value |
Onsite Access Bound Attachments |
Name | Current Value |
Onsite Access Data Movement Rules |
Name | Type | Rule Text/Value |
Onsite Access Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Onsite Access |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF ONSITE_ACC |
NO |
Onsite Access Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Onsite Access Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Onsite Access Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Onsite Access Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Controlled Area Access |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Controlled Area Access |
Logical Rolename | |
ColumnName | CTRL_AREA_ACC |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Controlled Area Access Logical Attribute Properties |
Logical Attribute Name | Controlled Area Access |
Datatype | VARCHAR(4000) |
Nullable | YES |
Controlled Area Access Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Controlled Area Access Security Types |
Name | Current Value |
Controlled Area Access Bound Attachments |
Name | Current Value |
Controlled Area Access Data Movement Rules |
Name | Type | Rule Text/Value |
Controlled Area Access Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Controlled Area Access |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF CTRL_AREA_ACC |
NO |
Controlled Area Access Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Controlled Area Access Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Controlled Area Access Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Controlled Area Access Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Onsite Day Number |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Onsite Day Number |
Logical Rolename | |
ColumnName | ONSITE_DAY_NBR |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Onsite Day Number Logical Attribute Properties |
Logical Attribute Name | Onsite Day Number |
Datatype | VARCHAR(4000) |
Nullable | YES |
Onsite Day Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Onsite Day Number Security Types |
Name | Current Value |
Onsite Day Number Bound Attachments |
Name | Current Value |
Onsite Day Number Data Movement Rules |
Name | Type | Rule Text/Value |
Onsite Day Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Onsite Day Number |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF ONSITE_DAY_NBR |
NO |
Onsite Day Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Onsite Day Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Onsite Day Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Onsite Day Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Building 24 Hour Access |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Building 24 Hour Access |
Logical Rolename | |
ColumnName | BLDG_24_ACC |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Building 24 Hour Access Logical Attribute Properties |
Logical Attribute Name | Building 24 Hour Access |
Datatype | VARCHAR(4000) |
Nullable | YES |
Building 24 Hour Access Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Building 24 Hour Access Security Types |
Name | Current Value |
Building 24 Hour Access Bound Attachments |
Name | Current Value |
Building 24 Hour Access Data Movement Rules |
Name | Type | Rule Text/Value |
Building 24 Hour Access Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Building 24 Hour Access |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF BLDG_24_ACC |
NO |
Building 24 Hour Access Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Building 24 Hour Access Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Building 24 Hour Access Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Building 24 Hour Access Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Building 6AM 8PM Access |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Building 6AM 8PM Access |
Logical Rolename | |
ColumnName | BLDG_6_8_ACC |
RoleName | |
Domain | Text |
Logical Only | NO |
Definition | |
Note |
Building 6AM 8PM Access Logical Attribute Properties |
Logical Attribute Name | Building 6AM 8PM Access |
Datatype | VARCHAR(4000) |
Nullable | YES |
Building 6AM 8PM Access Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Building 6AM 8PM Access Security Types |
Name | Current Value |
Building 6AM 8PM Access Bound Attachments |
Name | Current Value |
Building 6AM 8PM Access Data Movement Rules |
Name | Type | Rule Text/Value |
Building 6AM 8PM Access Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Building 6AM 8PM Access |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF BLDG_6_8_ACC |
NO |
Building 6AM 8PM Access Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Building 6AM 8PM Access Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Building 6AM 8PM Access Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Building 6AM 8PM Access Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Host Badge Number |
Base Entity | Personnel Access System Initial Request Default |
Attribute Name | Host Badge Number |
Logical Rolename | |
ColumnName | HOST_BN |
RoleName | |
Domain | Badge Number |
Logical Only | NO |
Definition | |
Note |
Host Badge Number Logical Attribute Properties |
Logical Attribute Name | Host Badge Number |
Datatype | VARCHAR(10) |
Nullable | YES |
Host Badge Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Host Badge Number Security Types |
Name | Current Value |
Host Badge Number Bound Attachments |
Name | Current Value |
Host Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Host Badge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Access System Initial Request Default Host Badge Number |
NO | ||
XF_ADMIN (Oracle) PAS_INIT_REQ_DEF HOST_BN |
NO |
Host Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Host Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Host Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Host Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |