PERSON_ID 
Base Object  PERSON 
Attribute Name  Person Identifier 
ColumnName  PERSON_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition  
Person Identifier: Unique identifier for a person derived from XCAMS.
 
Note 
 

PERSON_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PERSON_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null  0 

PERSON_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PERSON_ID Security Types 
Name  Current Value 

PERSON_ID Bound Attachments 
Name  Current Value 

PERSON_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PERSON_ID 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_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PERSON_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PERSON_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PERSON_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

BN 
Base Object  PERSON 
Attribute Name  Badge Number 
ColumnName  BN 
Logical Rolename   
RoleName   
Domain  Badge Number 
Physical Only  NO 
Definition 
 
Note 
 

BN Column Properties 
Datatype  VARCHAR2(10) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

BN Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null  0 

BN Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BN Security Types 
Name  Current Value 

BN Bound Attachments 
Name  Current Value 

BN Data Movement Rules 
Name  Type  Rule Text/Value 

BN 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     

BN Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BN Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BN Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BN Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

FIRST_NM Column Properties 
Datatype  VARCHAR2(64) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

FIRST_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  64 
Percent Null  0 

FIRST_NM Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

FIRST_NM Security Types 
Name  Current Value 

FIRST_NM Bound Attachments 
Name  Current Value 

FIRST_NM Data Movement Rules 
Name  Type  Rule Text/Value 

FIRST_NM 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_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FIRST_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FIRST_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FIRST_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_NM 
Base Object  PERSON 
Attribute Name  Last Name 
ColumnName  LAST_NM 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition  
Last Name: person last name.
 
Note 
 

LAST_NM Column Properties 
Datatype  VARCHAR2(64) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

LAST_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  64 
Percent Null  0 

LAST_NM Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LAST_NM Security Types 
Name  Current Value 

LAST_NM Bound Attachments 
Name  Current Value 

LAST_NM Data Movement Rules 
Name  Type  Rule Text/Value 

LAST_NM 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_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

USRNM 
Base Object  PERSON 
Attribute Name  Username 
ColumnName  USRNM 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition  
Username: XCAMS computer username.
 
Note 
 

USRNM Column Properties 
Datatype  VARCHAR2(64) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

USRNM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  64 
Percent Null  0 

USRNM Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

USRNM Security Types 
Name  Current Value 

USRNM Bound Attachments 
Name  Current Value 

USRNM Data Movement Rules 
Name  Type  Rule Text/Value 

USRNM 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     

USRNM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

USRNM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

USRNM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

USRNM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

EMAIL_ADDR Column Properties 
Datatype  VARCHAR2(100) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

EMAIL_ADDR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  100 
Percent Null  0 

EMAIL_ADDR Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EMAIL_ADDR Security Types 
Name  Current Value 

EMAIL_ADDR Bound Attachments 
Name  Current Value 

EMAIL_ADDR Data Movement Rules 
Name  Type  Rule Text/Value 

EMAIL_ADDR 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_ADDR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_ADDR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_ADDR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_ADDR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ST_ADDR 
Base Object  PERSON 
Attribute Name  Street Address 
ColumnName  ST_ADDR 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition  
Street Address:
 
Note 
 

ST_ADDR Column Properties 
Datatype  VARCHAR2(128) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ST_ADDR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  128 
Percent Null  0 

ST_ADDR Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ST_ADDR Security Types 
Name  Current Value 

ST_ADDR Bound Attachments 
Name  Current Value 

ST_ADDR Data Movement Rules 
Name  Type  Rule Text/Value 

ST_ADDR 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     

ST_ADDR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ST_ADDR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ST_ADDR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ST_ADDR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

CITY 
Base Object  PERSON 
Attribute Name  City 
ColumnName  CITY 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition  
City:
 
Note 
 

CITY Column Properties 
Datatype  VARCHAR2(100) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

CITY Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  100 
Percent Null  0 

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 Object  PERSON 
Attribute Name  State 
ColumnName  STATE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition  
State: US state or country province.
 
Note 
 

STATE Column Properties 
Datatype  VARCHAR2(100) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

STATE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  100 
Percent Null  0 

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 

POST_CD 
Base Object  PERSON 
Attribute Name  Postal Code 
ColumnName  POST_CD 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition  
Postal Code:
 
Note 
 

POST_CD Column Properties 
Datatype  VARCHAR2(20) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

POST_CD Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

POST_CD Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

POST_CD Security Types 
Name  Current Value 

POST_CD Bound Attachments 
Name  Current Value 

POST_CD Data Movement Rules 
Name  Type  Rule Text/Value 

POST_CD 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     

POST_CD Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

POST_CD Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

POST_CD Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

POST_CD Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

CNTRY_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

CNTRY_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null  0 

CNTRY_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CNTRY_ID Security Types 
Name  Current Value 

CNTRY_ID Bound Attachments 
Name  Current Value 

CNTRY_ID Data Movement Rules 
Name  Type  Rule Text/Value 

CNTRY_ID 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     

CNTRY_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CNTRY_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CNTRY_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CNTRY_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

PHONE_NBR Column Properties 
Datatype  VARCHAR2(20) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PHONE_NBR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

PHONE_NBR Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PHONE_NBR Security Types 
Name  Current Value 

PHONE_NBR Bound Attachments 
Name  Current Value 

PHONE_NBR Data Movement Rules 
Name  Type  Rule Text/Value 

PHONE_NBR 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_NBR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PHONE_NBR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PHONE_NBR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PHONE_NBR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

CELL_NBR 
Base Object  PERSON 
Attribute Name  Cell Number 
ColumnName  CELL_NBR 
Logical Rolename   
RoleName   
Domain  Phone 
Physical Only  NO 
Definition 
 
Note 
 

CELL_NBR Column Properties 
Datatype  VARCHAR2(20) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

CELL_NBR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

CELL_NBR Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CELL_NBR Security Types 
Name  Current Value 

CELL_NBR Bound Attachments 
Name  Current Value 

CELL_NBR Data Movement Rules 
Name  Type  Rule Text/Value 

CELL_NBR 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_NBR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CELL_NBR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CELL_NBR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CELL_NBR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

INST_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

INST_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

INST_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

INST_ID Security Types 
Name  Current Value 

INST_ID Bound Attachments 
Name  Current Value 

INST_ID Data Movement Rules 
Name  Type  Rule Text/Value 

INST_ID 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     

INST_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INST_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INST_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INST_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

INST_DEPT 
Base Object  PERSON 
Attribute Name  Institute Department 
ColumnName  INST_DEPT 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

INST_DEPT Column Properties 
Datatype  VARCHAR2(100) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

INST_DEPT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  100 
Percent Null  0 

INST_DEPT Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

INST_DEPT Security Types 
Name  Current Value 

INST_DEPT Bound Attachments 
Name  Current Value 

INST_DEPT Data Movement Rules 
Name  Type  Rule Text/Value 

INST_DEPT 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     

INST_DEPT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INST_DEPT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INST_DEPT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INST_DEPT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

NOTIF_READ_IND 
Base Object  PERSON 
Attribute Name  Notification Read Indicator 
ColumnName  NOTIF_READ_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

NOTIF_READ_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

NOTIF_READ_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

NOTIF_READ_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

NOTIF_READ_IND 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 

NOTIF_READ_IND Security Types 
Name  Current Value 

NOTIF_READ_IND Bound Attachments 
Name  Current Value 

NOTIF_READ_IND Data Movement Rules 
Name  Type  Rule Text/Value 

NOTIF_READ_IND 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     

NOTIF_READ_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NOTIF_READ_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NOTIF_READ_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NOTIF_READ_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

PAS_START_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PAS_START_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

PAS_START_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

PAS_START_DTE Security Types 
Name  Current Value 

PAS_START_DTE Bound Attachments 
Name  Current Value 

PAS_START_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

PAS_START_DTE 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     

PAS_START_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PAS_START_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PAS_START_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PAS_START_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

PAS_END_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PAS_END_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

PAS_END_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

PAS_END_DTE Security Types 
Name  Current Value 

PAS_END_DTE Bound Attachments 
Name  Current Value 

PAS_END_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

PAS_END_DTE 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     

PAS_END_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PAS_END_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PAS_END_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PAS_END_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

SAT_EXP_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SAT_EXP_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

SAT_EXP_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

SAT_EXP_DTE Security Types 
Name  Current Value 

SAT_EXP_DTE Bound Attachments 
Name  Current Value 

SAT_EXP_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

SAT_EXP_DTE 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     

SAT_EXP_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SAT_EXP_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SAT_EXP_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SAT_EXP_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

SNS_ACC_EXP_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SNS_ACC_EXP_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

SNS_ACC_EXP_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

SNS_ACC_EXP_DTE Security Types 
Name  Current Value 

SNS_ACC_EXP_DTE Bound Attachments 
Name  Current Value 

SNS_ACC_EXP_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

SNS_ACC_EXP_DTE 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_ACC_EXP_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SNS_ACC_EXP_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SNS_ACC_EXP_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SNS_ACC_EXP_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

HFIR_ACC_EXP_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

HFIR_ACC_EXP_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

HFIR_ACC_EXP_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

HFIR_ACC_EXP_DTE Security Types 
Name  Current Value 

HFIR_ACC_EXP_DTE Bound Attachments 
Name  Current Value 

HFIR_ACC_EXP_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

HFIR_ACC_EXP_DTE 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_ACC_EXP_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR_ACC_EXP_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR_ACC_EXP_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR_ACC_EXP_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

RWT_EXP_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

RWT_EXP_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

RWT_EXP_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

RWT_EXP_DTE Security Types 
Name  Current Value 

RWT_EXP_DTE Bound Attachments 
Name  Current Value 

RWT_EXP_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

RWT_EXP_DTE 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     

RWT_EXP_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RWT_EXP_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RWT_EXP_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RWT_EXP_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

ORG_APPR_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ORG_APPR_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

ORG_APPR_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

ORG_APPR_DTE Security Types 
Name  Current Value 

ORG_APPR_DTE Bound Attachments 
Name  Current Value 

ORG_APPR_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

ORG_APPR_DTE 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     

ORG_APPR_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_APPR_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_APPR_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_APPR_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

RESEARCH_ID 
Base Object  PERSON 
Attribute Name  Researcher Identifier 
ColumnName  RESEARCH_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical 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 
 

RESEARCH_ID Column Properties 
Datatype  VARCHAR2(20) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

RESEARCH_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

RESEARCH_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RESEARCH_ID Security Types 
Name  Current Value 

RESEARCH_ID Bound Attachments 
Name  Current Value 

RESEARCH_ID Data Movement Rules 
Name  Type  Rule Text/Value 

RESEARCH_ID 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     

RESEARCH_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RESEARCH_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RESEARCH_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RESEARCH_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID_ID 
Base Object  PERSON 
Attribute Name  ORCID Identitifer 
ColumnName  ORCID_ID 
Logical Rolename   
RoleName   
Domain  URI 
Physical 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_ID Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ORCID_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

ORCID_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ORCID_ID Security Types 
Name  Current Value 

ORCID_ID Bound Attachments 
Name  Current Value 

ORCID_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ORCID_ID 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_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORCID_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

NEU_SCHOOL_STUD_IND 
Base Object  PERSON 
Attribute Name  Neutron School Student Indicator 
ColumnName  NEU_SCHOOL_STUD_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

NEU_SCHOOL_STUD_IND Column Properties 
Datatype  CHAR(1) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

NEU_SCHOOL_STUD_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

NEU_SCHOOL_STUD_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

NEU_SCHOOL_STUD_IND 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 

NEU_SCHOOL_STUD_IND Security Types 
Name  Current Value 

NEU_SCHOOL_STUD_IND Bound Attachments 
Name  Current Value 

NEU_SCHOOL_STUD_IND Data Movement Rules 
Name  Type  Rule Text/Value 

NEU_SCHOOL_STUD_IND 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     

NEU_SCHOOL_STUD_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NEU_SCHOOL_STUD_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NEU_SCHOOL_STUD_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NEU_SCHOOL_STUD_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description