Person Identifier 
Base Entity  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
Person
Person Identifier 		 NO     
CNMS_PRPSL (Oracle)
PERSON
PERSON_ID 		 NO     
ENGA (Oracle)
PERSON
PERSON_ID 		 NO     
EXPRESS (Oracle)
PERSON
PERSON_ID 		 NO     
IPTSv5 (Oracle)
PERSON
PERSON_ID 		 NO     
PRPSL (Oracle)
PERSON
PERSON_ID 		 NO     
PUBL (Oracle)
PERSON
PERSON_ID 		 NO     
XF_ADMIN (Oracle)
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 

Badge Number 
Base Entity  Person 
Attribute Name  Badge Number 
Logical Rolename   
ColumnName  BN 
RoleName   
Domain  Badge Number 
Logical Only  NO 
Definition 
 
Note 
 

Badge Number Logical Attribute Properties 
Logical Attribute Name  Badge Number 
Datatype  VARCHAR(10) 
Nullable  YES 

Badge Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Badge Number Security Types 
Name  Current Value 

Badge Number Bound Attachments 
Name  Current Value 

Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Badge Number 		 NO     
CNMS_PRPSL (Oracle)
PERSON
BN 		 NO     
ENGA (Oracle)
PERSON
BN 		 NO     
EXPRESS (Oracle)
PERSON
BN 		 NO     
IPTSv5 (Oracle)
PERSON
BN 		 NO     
PRPSL (Oracle)
PERSON
BN 		 NO     
PUBL (Oracle)
PERSON
BN 		 NO     
XF_ADMIN (Oracle)
PERSON
BN 		 NO     

Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

First Name 
Base Entity  Person 
Attribute Name  First Name 
Logical Rolename   
ColumnName  FIRST_NM 
RoleName   
Domain   
Logical Only  NO 
Definition  
First Name: Person first name.
 
Note 
 

First Name Logical Attribute Properties 
Logical Attribute Name  First Name 
Datatype  VARCHAR(64) 
Nullable  NO 

First Name Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
First Name Security Types 
Name  Current Value 

First Name Bound Attachments 
Name  Current Value 

First Name Data Movement Rules 
Name  Type  Rule Text/Value 

First Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
First Name 		 NO     
CNMS_PRPSL (Oracle)
PERSON
FIRST_NM 		 NO     
ENGA (Oracle)
PERSON
FIRST_NM 		 NO     
EXPRESS (Oracle)
PERSON
FIRST_NM 		 NO     
IPTSv5 (Oracle)
PERSON
FIRST_NM 		 NO     
PRPSL (Oracle)
PERSON
FIRST_NM 		 NO     
PUBL (Oracle)
PERSON
FIRST_NM 		 NO     
XF_ADMIN (Oracle)
PERSON
FIRST_NM 		 NO     

First Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

First Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

First Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

First Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Last Name 
Base Entity  Person 
Attribute Name  Last Name 
Logical Rolename   
ColumnName  LAST_NM 
RoleName   
Domain   
Logical Only  NO 
Definition  
Last Name: person last name.
 
Note 
 

Last Name Logical Attribute Properties 
Logical Attribute Name  Last Name 
Datatype  VARCHAR(64) 
Nullable  NO 

Last Name Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Last Name Security Types 
Name  Current Value 

Last Name Bound Attachments 
Name  Current Value 

Last Name Data Movement Rules 
Name  Type  Rule Text/Value 

Last Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Last Name 		 NO     
CNMS_PRPSL (Oracle)
PERSON
LAST_NM 		 NO     
ENGA (Oracle)
PERSON
LAST_NM 		 NO     
EXPRESS (Oracle)
PERSON
LAST_NM 		 NO     
IPTSv5 (Oracle)
PERSON
LAST_NM 		 NO     
PRPSL (Oracle)
PERSON
LAST_NM 		 NO     
PUBL (Oracle)
PERSON
LAST_NM 		 NO     
XF_ADMIN (Oracle)
PERSON
LAST_NM 		 NO     

Last Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Last Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Last Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Last Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Username 
Base Entity  Person 
Attribute Name  Username 
Logical Rolename   
ColumnName  USRNM 
RoleName   
Domain   
Logical Only  NO 
Definition  
Username: XCAMS computer username.
 
Note 
 

Username Logical Attribute Properties 
Logical Attribute Name  Username 
Datatype  VARCHAR(64) 
Nullable  YES 

Username Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Username Security Types 
Name  Current Value 

Username Bound Attachments 
Name  Current Value 

Username Data Movement Rules 
Name  Type  Rule Text/Value 

Username Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Username 		 NO     
CNMS_PRPSL (Oracle)
PERSON
USRNM 		 NO     
ENGA (Oracle)
PERSON
USRNM 		 NO     
EXPRESS (Oracle)
PERSON
USRNM 		 NO     
IPTSv5 (Oracle)
PERSON
USRNM 		 NO     
PRPSL (Oracle)
PERSON
USRNM 		 NO     
PUBL (Oracle)
PERSON
USRNM 		 NO     
XF_ADMIN (Oracle)
PERSON
USRNM 		 NO     

Username Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Username Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Username Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Username Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Email Address 
Base Entity  Person 
Attribute Name  Email Address 
Logical Rolename   
ColumnName  EMAIL_ADDR 
RoleName   
Domain   
Logical Only  NO 
Definition  
Email Address: Person email address.
 
Note 
 

Email Address Logical Attribute Properties 
Logical Attribute Name  Email Address 
Datatype  VARCHAR(100) 
Nullable  NO 

Email Address Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Email Address Security Types 
Name  Current Value 

Email Address Bound Attachments 
Name  Current Value 

Email Address Data Movement Rules 
Name  Type  Rule Text/Value 

Email Address Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Email Address 		 NO     
CNMS_PRPSL (Oracle)
PERSON
EMAIL_ADDR 		 NO     
ENGA (Oracle)
PERSON
EMAIL_ADDR 		 NO     
EXPRESS (Oracle)
PERSON
EMAIL_ADDR 		 NO     
IPTSv5 (Oracle)
PERSON
EMAIL_ADDR 		 NO     
PRPSL (Oracle)
PERSON
EMAIL_ADDR 		 NO     
PUBL (Oracle)
PERSON
EMAIL_ADDR 		 NO     
XF_ADMIN (Oracle)
PERSON
EMAIL_ADDR 		 NO     

Email Address Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Email Address Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Email Address Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Email Address Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Street Address 
Base Entity  Person 
Attribute Name  Street Address 
Logical Rolename   
ColumnName  ST_ADDR 
RoleName   
Domain   
Logical Only  NO 
Definition  
Street Address:
 
Note 
 

Street Address Logical Attribute Properties 
Logical Attribute Name  Street Address 
Datatype  VARCHAR(128) 
Nullable  NO 

Street Address Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Street Address Security Types 
Name  Current Value 

Street Address Bound Attachments 
Name  Current Value 

Street Address Data Movement Rules 
Name  Type  Rule Text/Value 

Street Address Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Street Address 		 NO     
CNMS_PRPSL (Oracle)
PERSON
ST_ADDR 		 NO     
ENGA (Oracle)
PERSON
ST_ADDR 		 NO     
EXPRESS (Oracle)
PERSON
ST_ADDR 		 NO     
IPTSv5 (Oracle)
PERSON
ST_ADDR 		 NO     
PRPSL (Oracle)
PERSON
ST_ADDR 		 NO     
PUBL (Oracle)
PERSON
ST_ADDR 		 NO     
XF_ADMIN (Oracle)
PERSON
ST_ADDR 		 NO     

Street Address Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Street Address Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Street Address Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Street Address Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

City 
Base Entity  Person 
Attribute Name  City 
Logical Rolename   
ColumnName  CITY 
RoleName   
Domain   
Logical Only  NO 
Definition  
City:
 
Note 
 

City Logical Attribute Properties 
Logical Attribute Name  City 
Datatype  VARCHAR(100) 
Nullable  NO 

City Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
City Security Types 
Name  Current Value 

City Bound Attachments 
Name  Current Value 

City Data Movement Rules 
Name  Type  Rule Text/Value 

City Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
City 		 NO     
CNMS_PRPSL (Oracle)
PERSON
CITY 		 NO     
ENGA (Oracle)
PERSON
CITY 		 NO     
EXPRESS (Oracle)
PERSON
CITY 		 NO     
IPTSv5 (Oracle)
PERSON
CITY 		 NO     
PRPSL (Oracle)
PERSON
CITY 		 NO     
PUBL (Oracle)
PERSON
CITY 		 NO     
XF_ADMIN (Oracle)
PERSON
CITY 		 NO     

City Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

City Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

City Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

City Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

State 
Base Entity  Person 
Attribute Name  State 
Logical Rolename   
ColumnName  STATE 
RoleName   
Domain   
Logical Only  NO 
Definition  
State: US state or country province.
 
Note 
 

State Logical Attribute Properties 
Logical Attribute Name  State 
Datatype  VARCHAR(100) 
Nullable  NO 

State Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
State Security Types 
Name  Current Value 

State Bound Attachments 
Name  Current Value 

State Data Movement Rules 
Name  Type  Rule Text/Value 

State Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
State 		 NO     
CNMS_PRPSL (Oracle)
PERSON
STATE 		 NO     
ENGA (Oracle)
PERSON
STATE 		 NO     
EXPRESS (Oracle)
PERSON
STATE 		 NO     
IPTSv5 (Oracle)
PERSON
STATE 		 NO     
PRPSL (Oracle)
PERSON
STATE 		 NO     
PUBL (Oracle)
PERSON
STATE 		 NO     
XF_ADMIN (Oracle)
PERSON
STATE 		 NO     

State Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

State Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

State Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

State Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Postal Code 
Base Entity  Person 
Attribute Name  Postal Code 
Logical Rolename   
ColumnName  POST_CD 
RoleName   
Domain   
Logical Only  NO 
Definition  
Postal Code:
 
Note 
 

Postal Code Logical Attribute Properties 
Logical Attribute Name  Postal Code 
Datatype  VARCHAR(20) 
Nullable  NO 

Postal Code Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Postal Code Security Types 
Name  Current Value 

Postal Code Bound Attachments 
Name  Current Value 

Postal Code Data Movement Rules 
Name  Type  Rule Text/Value 

Postal Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Postal Code 		 NO     
CNMS_PRPSL (Oracle)
PERSON
POST_CD 		 NO     
ENGA (Oracle)
PERSON
POST_CD 		 NO     
EXPRESS (Oracle)
PERSON
POST_CD 		 NO     
IPTSv5 (Oracle)
PERSON
POST_CD 		 NO     
PRPSL (Oracle)
PERSON
POST_CD 		 NO     
PUBL (Oracle)
PERSON
POST_CD 		 NO     
XF_ADMIN (Oracle)
PERSON
POST_CD 		 NO     

Postal Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Postal Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Postal Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Postal Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Country Identifier 
Base Entity  Person 
Attribute Name  Country Identifier 
Logical Rolename   
ColumnName  CNTRY_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Country Identifier: Abbreviated identrifier for a country.
 
Note 
 

Country Identifier Logical Attribute Properties 
Logical Attribute Name  Country Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

Country Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Country Identifier Security Types 
Name  Current Value 

Country Identifier Bound Attachments 
Name  Current Value 

Country Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Country Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Country Identifier 		 NO     
CNMS_PRPSL (Oracle)
PERSON
CNTRY_ID 		 NO     
ENGA (Oracle)
PERSON
CNTRY_ID 		 NO     
EXPRESS (Oracle)
PERSON
CNTRY_ID 		 NO     
IPTSv5 (Oracle)
PERSON
CNTRY_ID 		 NO     
PRPSL (Oracle)
PERSON
CNTRY_ID 		 NO     
PUBL (Oracle)
PERSON
CNTRY_ID 		 NO     
XF_ADMIN (Oracle)
PERSON
CNTRY_ID 		 NO     

Country Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Country Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Country Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Country Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Phone Number 
Base Entity  Person 
Attribute Name  Phone Number 
Logical Rolename   
ColumnName  PHONE_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition  
Phone Number: Numeric text and separator characters possibly including country code.
 
Note 
 

Phone Number Logical Attribute Properties 
Logical Attribute Name  Phone Number 
Datatype  VARCHAR(20) 
Nullable  NO 

Phone Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Phone Number Security Types 
Name  Current Value 

Phone Number Bound Attachments 
Name  Current Value 

Phone Number Data Movement Rules 
Name  Type  Rule Text/Value 

Phone Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Phone Number 		 NO     
CNMS_PRPSL (Oracle)
PERSON
PHONE_NBR 		 NO     
ENGA (Oracle)
PERSON
PHONE_NBR 		 NO     
EXPRESS (Oracle)
PERSON
PHONE_NBR 		 NO     
IPTSv5 (Oracle)
PERSON
PHONE_NBR 		 NO     
PRPSL (Oracle)
PERSON
PHONE_NBR 		 NO     
PUBL (Oracle)
PERSON
PHONE_NBR 		 NO     
XF_ADMIN (Oracle)
PERSON
PHONE_NBR 		 NO     

Phone Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Phone Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Phone Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Phone Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Number 
Base Entity  Person 
Attribute Name  Cell Number 
Logical Rolename   
ColumnName  CELL_NBR 
RoleName   
Domain  Phone 
Logical Only  NO 
Definition 
 
Note 
 

Cell Number Logical Attribute Properties 
Logical Attribute Name  Cell Number 
Datatype  VARCHAR(20) 
Nullable  YES 

Cell Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Cell Number Security Types 
Name  Current Value 

Cell Number Bound Attachments 
Name  Current Value 

Cell Number Data Movement Rules 
Name  Type  Rule Text/Value 

Cell Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Cell Number 		 NO     
CNMS_PRPSL (Oracle)
PERSON
CELL_NBR 		 NO     
ENGA (Oracle)
PERSON
CELL_NBR 		 NO     
EXPRESS (Oracle)
PERSON
CELL_NBR 		 NO     
IPTSv5 (Oracle)
PERSON
CELL_NBR 		 NO     
PRPSL (Oracle)
PERSON
CELL_NBR 		 NO     
PUBL (Oracle)
PERSON
CELL_NBR 		 NO     
XF_ADMIN (Oracle)
PERSON
CELL_NBR 		 NO     

Cell Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier 
Base Entity  Person 
Attribute Name  Institute Identifier 
Logical Rolename   
ColumnName  INST_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Institute Identifer: Abbreviated identifier for a institute.
 
Note 
 

Institute Identifier Logical Attribute Properties 
Logical Attribute Name  Institute Identifier 
Datatype  INTEGER 
Nullable  NO 

Institute Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Institute Identifier Security Types 
Name  Current Value 

Institute Identifier Bound Attachments 
Name  Current Value 

Institute Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Institute Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Institute Identifier 		 NO     
CNMS_PRPSL (Oracle)
PERSON
INST_ID 		 NO     
ENGA (Oracle)
PERSON
INST_ID 		 NO     
EXPRESS (Oracle)
PERSON
INST_ID 		 NO     
IPTSv5 (Oracle)
PERSON
INST_ID 		 NO     
PRPSL (Oracle)
PERSON
INST_ID 		 NO     
PUBL (Oracle)
PERSON
INST_ID 		 NO     
XF_ADMIN (Oracle)
PERSON
INST_ID 		 NO     

Institute Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Department 
Base Entity  Person 
Attribute Name  Institute Department 
Logical Rolename   
ColumnName  INST_DEPT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Institute Department Logical Attribute Properties 
Logical Attribute Name  Institute Department 
Datatype  VARCHAR(100) 
Nullable  YES 

Institute Department Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Institute Department Security Types 
Name  Current Value 

Institute Department Bound Attachments 
Name  Current Value 

Institute Department Data Movement Rules 
Name  Type  Rule Text/Value 

Institute Department Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Institute Department 		 NO     
CNMS_PRPSL (Oracle)
PERSON
INST_DEPT 		 NO     
ENGA (Oracle)
PERSON
INST_DEPT 		 NO     
EXPRESS (Oracle)
PERSON
INST_DEPT 		 NO     
IPTSv5 (Oracle)
PERSON
INST_DEPT 		 NO     
PRPSL (Oracle)
PERSON
INST_DEPT 		 NO     
PUBL (Oracle)
PERSON
INST_DEPT 		 NO     
XF_ADMIN (Oracle)
PERSON
INST_DEPT 		 NO     

Institute Department Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Department Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Department Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Department Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Notification Read Indicator 
Base Entity  Person 
Attribute Name  Notification Read Indicator 
Logical Rolename   
ColumnName  NOTIF_READ_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Notification Read Indicator Logical Attribute Properties 
Logical Attribute Name  Notification Read Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Notification Read Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Notification Read 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 

Notification Read Indicator Security Types 
Name  Current Value 

Notification Read Indicator Bound Attachments 
Name  Current Value 

Notification Read Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Notification Read Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Notification Read Indicator 		 NO     
CNMS_PRPSL (Oracle)
PERSON
NOTIF_READ_IND 		 NO     
ENGA (Oracle)
PERSON
NOTIF_READ_IND 		 NO     
EXPRESS (Oracle)
PERSON
NOTIF_READ_IND 		 NO     
IPTSv5 (Oracle)
PERSON
NOTIF_READ_IND 		 NO     
PRPSL (Oracle)
PERSON
NOTIF_READ_IND 		 NO     
PUBL (Oracle)
PERSON
NOTIF_READ_IND 		 NO     
XF_ADMIN (Oracle)
PERSON
NOTIF_READ_IND 		 NO     

Notification Read Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Notification Read Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Notification Read Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Notification Read Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Personnel Access System Start Date 
Base Entity  Person 
Attribute Name  Personnel Access System Start Date 
Logical Rolename   
ColumnName  PAS_START_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Personnel Access System Start Date Logical Attribute Properties 
Logical Attribute Name  Personnel Access System Start Date 
Datatype  DATE 
Nullable  NO 

Personnel Access System Start Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Personnel Access System Start Date Security Types 
Name  Current Value 

Personnel Access System Start Date Bound Attachments 
Name  Current Value 

Personnel Access System Start Date Data Movement Rules 
Name  Type  Rule Text/Value 

Personnel Access System Start Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Personnel Access System Start Date 		 NO     
CNMS_PRPSL (Oracle)
PERSON
PAS_START_DTE 		 NO     
ENGA (Oracle)
PERSON
PAS_START_DTE 		 NO     
EXPRESS (Oracle)
PERSON
PAS_START_DTE 		 NO     
IPTSv5 (Oracle)
PERSON
PAS_START_DTE 		 NO     
PRPSL (Oracle)
PERSON
PAS_START_DTE 		 NO     
PUBL (Oracle)
PERSON
PAS_START_DTE 		 NO     
XF_ADMIN (Oracle)
PERSON
PAS_START_DTE 		 NO     

Personnel Access System Start Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Personnel Access System Start Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Personnel Access System Start Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Personnel Access System Start Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Personnel Access System End Date 
Base Entity  Person 
Attribute Name  Personnel Access System End Date 
Logical Rolename   
ColumnName  PAS_END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Personnel Access System End Date Logical Attribute Properties 
Logical Attribute Name  Personnel Access System End Date 
Datatype  DATE 
Nullable  NO 

Personnel Access System End Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Personnel Access System End Date Security Types 
Name  Current Value 

Personnel Access System End Date Bound Attachments 
Name  Current Value 

Personnel Access System End Date Data Movement Rules 
Name  Type  Rule Text/Value 

Personnel Access System End Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Personnel Access System End Date 		 NO     
CNMS_PRPSL (Oracle)
PERSON
PAS_END_DTE 		 NO     
ENGA (Oracle)
PERSON
PAS_END_DTE 		 NO     
EXPRESS (Oracle)
PERSON
PAS_END_DTE 		 NO     
IPTSv5 (Oracle)
PERSON
PAS_END_DTE 		 NO     
PRPSL (Oracle)
PERSON
PAS_END_DTE 		 NO     
PUBL (Oracle)
PERSON
PAS_END_DTE 		 NO     
XF_ADMIN (Oracle)
PERSON
PAS_END_DTE 		 NO     

Personnel Access System End Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Personnel Access System End Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Personnel Access System End Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Personnel Access System End Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Standard Access Training Expiration Date 
Base Entity  Person 
Attribute Name  Standard Access Training Expiration Date 
Logical Rolename   
ColumnName  SAT_EXP_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Standard Access Training Expiration Date Logical Attribute Properties 
Logical Attribute Name  Standard Access Training Expiration Date 
Datatype  DATE 
Nullable  NO 

Standard Access Training Expiration Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Standard Access Training Expiration Date Security Types 
Name  Current Value 

Standard Access Training Expiration Date Bound Attachments 
Name  Current Value 

Standard Access Training Expiration Date Data Movement Rules 
Name  Type  Rule Text/Value 

Standard Access Training Expiration Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Standard Access Training Expiration Date 		 NO     
CNMS_PRPSL (Oracle)
PERSON
SAT_EXP_DTE 		 NO     
ENGA (Oracle)
PERSON
SAT_EXP_DTE 		 NO     
EXPRESS (Oracle)
PERSON
SAT_EXP_DTE 		 NO     
IPTSv5 (Oracle)
PERSON
SAT_EXP_DTE 		 NO     
PRPSL (Oracle)
PERSON
SAT_EXP_DTE 		 NO     
PUBL (Oracle)
PERSON
SAT_EXP_DTE 		 NO     
XF_ADMIN (Oracle)
PERSON
SAT_EXP_DTE 		 NO     

Standard Access Training Expiration Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Standard Access Training Expiration Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Standard Access Training Expiration Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Standard Access Training Expiration Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SNS Access Expiration Date 
Base Entity  Person 
Attribute Name  SNS Access Expiration Date 
Logical Rolename   
ColumnName  SNS_ACC_EXP_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

SNS Access Expiration Date Logical Attribute Properties 
Logical Attribute Name  SNS Access Expiration Date 
Datatype  DATE 
Nullable  NO 

SNS Access Expiration Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

SNS Access Expiration Date Security Types 
Name  Current Value 

SNS Access Expiration Date Bound Attachments 
Name  Current Value 

SNS Access Expiration Date Data Movement Rules 
Name  Type  Rule Text/Value 

SNS Access Expiration Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
SNS Access Expiration Date 		 NO     
CNMS_PRPSL (Oracle)
PERSON
SNS_ACC_EXP_DTE 		 NO     
ENGA (Oracle)
PERSON
SNS_ACC_EXP_DTE 		 NO     
EXPRESS (Oracle)
PERSON
SNS_ACC_EXP_DTE 		 NO     
IPTSv5 (Oracle)
PERSON
SNS_ACC_EXP_DTE 		 NO     
PRPSL (Oracle)
PERSON
SNS_ACC_EXP_DTE 		 NO     
PUBL (Oracle)
PERSON
SNS_ACC_EXP_DTE 		 NO     
XF_ADMIN (Oracle)
PERSON
SNS_ACC_EXP_DTE 		 NO     

SNS Access Expiration Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SNS Access Expiration Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SNS Access Expiration Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SNS Access Expiration Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR Access Expiration Date 
Base Entity  Person 
Attribute Name  HFIR Access Expiration Date 
Logical Rolename   
ColumnName  HFIR_ACC_EXP_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

HFIR Access Expiration Date Logical Attribute Properties 
Logical Attribute Name  HFIR Access Expiration Date 
Datatype  DATE 
Nullable  NO 

HFIR Access Expiration Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

HFIR Access Expiration Date Security Types 
Name  Current Value 

HFIR Access Expiration Date Bound Attachments 
Name  Current Value 

HFIR Access Expiration Date Data Movement Rules 
Name  Type  Rule Text/Value 

HFIR Access Expiration Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
HFIR Access Expiration Date 		 NO     
CNMS_PRPSL (Oracle)
PERSON
HFIR_ACC_EXP_DTE 		 NO     
ENGA (Oracle)
PERSON
HFIR_ACC_EXP_DTE 		 NO     
EXPRESS (Oracle)
PERSON
HFIR_ACC_EXP_DTE 		 NO     
IPTSv5 (Oracle)
PERSON
HFIR_ACC_EXP_DTE 		 NO     
PRPSL (Oracle)
PERSON
HFIR_ACC_EXP_DTE 		 NO     
PUBL (Oracle)
PERSON
HFIR_ACC_EXP_DTE 		 NO     
XF_ADMIN (Oracle)
PERSON
HFIR_ACC_EXP_DTE 		 NO     

HFIR Access Expiration Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR Access Expiration Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR Access Expiration Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR Access Expiration Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Radiological Worker Training Expiration Date 
Base Entity  Person 
Attribute Name  Radiological Worker Training Expiration Date 
Logical Rolename   
ColumnName  RWT_EXP_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Radiological Worker Training Expiration Date Logical Attribute Properties 
Logical Attribute Name  Radiological Worker Training Expiration Date 
Datatype  DATE 
Nullable  NO 

Radiological Worker Training Expiration Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Radiological Worker Training Expiration Date Security Types 
Name  Current Value 

Radiological Worker Training Expiration Date Bound Attachments 
Name  Current Value 

Radiological Worker Training Expiration Date Data Movement Rules 
Name  Type  Rule Text/Value 

Radiological Worker Training Expiration Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Radiological Worker Training Expiration Date 		 NO     
CNMS_PRPSL (Oracle)
PERSON
RWT_EXP_DTE 		 NO     
ENGA (Oracle)
PERSON
RWT_EXP_DTE 		 NO     
EXPRESS (Oracle)
PERSON
RWT_EXP_DTE 		 NO     
IPTSv5 (Oracle)
PERSON
RWT_EXP_DTE 		 NO     
PRPSL (Oracle)
PERSON
RWT_EXP_DTE 		 NO     
PUBL (Oracle)
PERSON
RWT_EXP_DTE 		 NO     
XF_ADMIN (Oracle)
PERSON
RWT_EXP_DTE 		 NO     

Radiological Worker Training Expiration Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Radiological Worker Training Expiration Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Radiological Worker Training Expiration Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Radiological Worker Training Expiration Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Approval Date 
Base Entity  Person 
Attribute Name  Organization Approval Date 
Logical Rolename   
ColumnName  ORG_APPR_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Organization Approval Date: Date the request was sent for PAS approval by the instrument organization. (? )
 
Note 
 

Organization Approval Date Logical Attribute Properties 
Logical Attribute Name  Organization Approval Date 
Datatype  DATE 
Nullable  NO 

Organization Approval Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Organization Approval Date Security Types 
Name  Current Value 

Organization Approval Date Bound Attachments 
Name  Current Value 

Organization Approval Date Data Movement Rules 
Name  Type  Rule Text/Value 

Organization Approval Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Organization Approval Date 		 NO     
CNMS_PRPSL (Oracle)
PERSON
ORG_APPR_DTE 		 NO     
ENGA (Oracle)
PERSON
ORG_APPR_DTE 		 NO     
EXPRESS (Oracle)
PERSON
ORG_APPR_DTE 		 NO     
IPTSv5 (Oracle)
PERSON
ORG_APPR_DTE 		 NO     
PRPSL (Oracle)
PERSON
ORG_APPR_DTE 		 NO     
PUBL (Oracle)
PERSON
ORG_APPR_DTE 		 NO     
XF_ADMIN (Oracle)
PERSON
ORG_APPR_DTE 		 NO     

Organization Approval Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Approval Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Approval Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Approval Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Researcher Identifier 
Base Entity  Person 
Attribute Name  Researcher Identifier 
Logical Rolename   
ColumnName  RESEARCH_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition  
ResearcherID: A unique identifier assinged by Thomson Reuters to enable researchers to manage their publication lists, track their times cited counts and h-index, identify potential collaborators and avoid author misidentification. In addition, your ResearcherID information integrates with the Web of Science and is ORCID compliant, allowing you to claim and showcase your publications from a single one account.
 
Note 
 

Researcher Identifier Logical Attribute Properties 
Logical Attribute Name  Researcher Identifier 
Datatype  VARCHAR(20) 
Nullable  YES 

Researcher Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Researcher Identifier Security Types 
Name  Current Value 

Researcher Identifier Bound Attachments 
Name  Current Value 

Researcher Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Researcher Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Researcher Identifier 		 NO     
CNMS_PRPSL (Oracle)
PERSON
RESEARCH_ID 		 NO     
ENGA (Oracle)
PERSON
RESEARCH_ID 		 NO     
EXPRESS (Oracle)
PERSON
RESEARCH_ID 		 NO     
IPTSv5 (Oracle)
PERSON
RESEARCH_ID 		 NO     
PRPSL (Oracle)
PERSON
RESEARCH_ID 		 NO     
PUBL (Oracle)
PERSON
RESEARCH_ID 		 NO     
XF_ADMIN (Oracle)
PERSON
RESEARCH_ID 		 NO     

Researcher Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Researcher Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Researcher Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Researcher Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID Identitifer 
Base Entity  Person 
Attribute Name  ORCID Identitifer 
Logical Rolename   
ColumnName  ORCID_ID 
RoleName   
Domain  URI 
Logical Only  NO 
Definition  
ORCID Id: The ORCID iD is a URI with a 16-digit number that is compatible with the ISO Standard (ISO 27729), also known as the International Standard Name Identifier (ISNI). Initially ORCID iDs will be randomly assigned by the ORCID Registry from a block of numbers that will not conflict with ISNI-formatted numbers assigned in other ways. ORCID iDs always need all 16-digits; they can not be shortened to remove leading zeros if they exist.



Expressing the ORCID iD

The ORCID iD is expressed as a HTTP URI; the number is proceeded by "http://orcid.org/". A hyphen is inserted every 4 digits to aid readability.



Storage of the ORCID iD in a database

The ORCID iD should always be expressed and stored as a URI: http://orcid.org/xxxx-xxxx-xxxx-xxxx (with the protocol (http://), and with hyphens in the number xxxx-xxxx-xxxx-xxxx).
 
Note 
 

ORCID Identitifer Logical Attribute Properties 
Logical Attribute Name  ORCID Identitifer 
Datatype  VARCHAR(255) 
Nullable  YES 

ORCID Identitifer Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ORCID Identitifer Security Types 
Name  Current Value 

ORCID Identitifer Bound Attachments 
Name  Current Value 

ORCID Identitifer Data Movement Rules 
Name  Type  Rule Text/Value 

ORCID Identitifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
ORCID Identitifer 		 NO     
CNMS_PRPSL (Oracle)
PERSON
ORCID_ID 		 NO     
ENGA (Oracle)
PERSON
ORCID_ID 		 NO     
EXPRESS (Oracle)
PERSON
ORCID_ID 		 NO     
IPTSv5 (Oracle)
PERSON
ORCID_ID 		 NO     
PRPSL (Oracle)
PERSON
ORCID_ID 		 NO     
PUBL (Oracle)
PERSON
ORCID_ID 		 NO     
XF_ADMIN (Oracle)
PERSON
ORCID_ID 		 NO     

ORCID Identitifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID Identitifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID Identitifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID Identitifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron School Student Indicator 
Base Entity  Person 
Attribute Name  Neutron School Student Indicator 
Logical Rolename   
ColumnName  NEU_SCHOOL_STUD_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Neutron School Student Indicator Logical Attribute Properties 
Logical Attribute Name  Neutron School Student Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Neutron School Student Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Neutron School Student 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 

Neutron School Student Indicator Security Types 
Name  Current Value 

Neutron School Student Indicator Bound Attachments 
Name  Current Value 

Neutron School Student Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Neutron School Student Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person
Neutron School Student Indicator 		 NO     
CNMS_PRPSL (Oracle)
PERSON
NEU_SCHOOL_STUD_IND 		 NO     
ENGA (Oracle)
PERSON
NEU_SCHOOL_STUD_IND 		 NO     
EXPRESS (Oracle)
PERSON
NEU_SCHOOL_STUD_IND 		 NO     
IPTSv5 (Oracle)
PERSON
NEU_SCHOOL_STUD_IND 		 NO     
PRPSL (Oracle)
PERSON
NEU_SCHOOL_STUD_IND 		 NO     
PUBL (Oracle)
PERSON
NEU_SCHOOL_STUD_IND 		 NO     
XF_ADMIN (Oracle)
PERSON
NEU_SCHOOL_STUD_IND 		 NO     

Neutron School Student Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron School Student Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron School Student Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron School Student Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description