| Person Identifier |
| Base Entity | Training Person |
| Attribute Name | Person Identifier |
| Logical Rolename | |
| ColumnName | PERSON_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
| Note |
| Person Identifier Logical Attribute Properties |
| Logical Attribute Name | Person Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Person Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Person Identifier Security Types |
| Name | Current Value |
| Person Identifier Bound Attachments |
| Name | Current Value |
| Person Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Person Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Training Person Person Identifier |
NO | ||
| XF_ADMIN (Oracle) TRAIN_PERSON PERSON_ID |
NO |
| Person Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Module Identifier |
| Base Entity | Training Person |
| Attribute Name | Module Identifier |
| Logical Rolename | |
| ColumnName | MOD_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Module Identifier Logical Attribute Properties |
| Logical Attribute Name | Module Identifier |
| Datatype | VARCHAR(25) |
| Nullable | NO |
| Module Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Module Identifier Security Types |
| Name | Current Value |
| Module Identifier Bound Attachments |
| Name | Current Value |
| Module Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Module Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Training Person Module Identifier |
NO | ||
| XF_ADMIN (Oracle) TRAIN_PERSON MOD_ID |
NO |
| Module Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Module Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Module Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Module Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Complete Date |
| Base Entity | Training Person |
| Attribute Name | Complete Date |
| Logical Rolename | |
| ColumnName | CMPLT_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Complete Date Logical Attribute Properties |
| Logical Attribute Name | Complete Date |
| Datatype | DATE |
| Nullable | NO |
| Complete Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Complete Date Security Types |
| Name | Current Value |
| Complete Date Bound Attachments |
| Name | Current Value |
| Complete Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Complete Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Training Person Complete Date |
NO | ||
| XF_ADMIN (Oracle) TRAIN_PERSON CMPLT_DTE |
NO |
| Complete Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Complete Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Complete Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Complete Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Certify Badge Number |
| Base Entity | Training Person |
| Attribute Name | Badge Number |
| Logical Rolename | Certify Badge Number |
| ColumnName | CERT_BN |
| RoleName | CERT_BN |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Certify Badge Number Logical Attribute Properties |
| Logical Attribute Name | Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Certify Badge Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Certify Badge Number Security Types |
| Name | Current Value |
| Certify Badge Number Bound Attachments |
| Name | Current Value |
| Certify Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Certify Badge Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Training Person Badge Number |
NO | ||
| XF_ADMIN (Oracle) TRAIN_PERSON CERT_BN |
NO |
| Certify Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Certify Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Certify Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Certify Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Learning Resource Network Indicator |
| Base Entity | Training Person |
| Attribute Name | Learning Resource Network Indicator |
| Logical Rolename | |
| ColumnName | LRN_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Learning Resource Network Indicator: Indicates training has been manually entered into LRN. |
| Note |
| Learning Resource Network Indicator Logical Attribute Properties |
| Logical Attribute Name | Learning Resource Network Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Learning Resource Network Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Learning Resource Network Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Learning Resource Network Indicator Security Types |
| Name | Current Value |
| Learning Resource Network Indicator Bound Attachments |
| Name | Current Value |
| Learning Resource Network Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Learning Resource Network Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Training Person Learning Resource Network Indicator |
NO | ||
| XF_ADMIN (Oracle) TRAIN_PERSON LRN_IND |
NO |
| Learning Resource Network Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Learning Resource Network Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Learning Resource Network Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Learning Resource Network Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |