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 | Institute Identifier |
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. |
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 |