| BN |
| Base Object | USER_PROF |
| Attribute Name | Badge Number |
| ColumnName | BN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| 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 User Profile Badge Number |
NO | ||
| Logical User Profile Badge Number |
NO | ||
| Logical User Profile Badge Number |
NO | ||
| EXPRESS (Oracle) USER_PROF BN |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE BN |
NO | ||
| PRPSL (Oracle) USER_PROFILE BN |
NO | ||
| SMPL (Oracle) USER_PROFILE 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 |
| DEF_PAGE |
| Base Object | USER_PROF |
| Attribute Name | Default Page |
| ColumnName | DEF_PAGE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DEF_PAGE Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DEF_PAGE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| DEF_PAGE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DEF_PAGE Security Types |
| Name | Current Value |
| DEF_PAGE Bound Attachments |
| Name | Current Value |
| DEF_PAGE Data Movement Rules |
| Name | Type | Rule Text/Value |
| DEF_PAGE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Default Page |
NO | ||
| Logical User Profile Default Page |
NO | ||
| Logical User Profile Default Page |
NO | ||
| EXPRESS (Oracle) USER_PROF DEF_PAGE |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE DEF_PAGE |
NO | ||
| PRPSL (Oracle) USER_PROFILE DEF_PAGE |
NO | ||
| SMPL (Oracle) USER_PROFILE DEF_PAGE |
NO |
| DEF_PAGE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_PAGE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_PAGE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_PAGE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_STRT_TIME |
| Base Object | USER_PROF |
| Attribute Name | Default Start Time |
| ColumnName | DEF_STRT_TIME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DEF_STRT_TIME Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DEF_STRT_TIME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| DEF_STRT_TIME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DEF_STRT_TIME Security Types |
| Name | Current Value |
| DEF_STRT_TIME Bound Attachments |
| Name | Current Value |
| DEF_STRT_TIME Data Movement Rules |
| Name | Type | Rule Text/Value |
| DEF_STRT_TIME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Default Start Time |
NO | ||
| Logical User Profile Default Start Time |
NO | ||
| Logical User Profile Default Start Time |
NO | ||
| EXPRESS (Oracle) USER_PROF DEF_STRT_TIME |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE DEF_STRT_TIME |
NO | ||
| PRPSL (Oracle) USER_PROFILE DEF_STRT_TIME |
NO | ||
| SMPL (Oracle) USER_PROFILE DEF_STRT_TIME |
NO |
| DEF_STRT_TIME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_STRT_TIME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_STRT_TIME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_STRT_TIME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_END_TIME |
| Base Object | USER_PROF |
| Attribute Name | Default End Time |
| ColumnName | DEF_END_TIME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DEF_END_TIME Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DEF_END_TIME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| DEF_END_TIME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DEF_END_TIME Security Types |
| Name | Current Value |
| DEF_END_TIME Bound Attachments |
| Name | Current Value |
| DEF_END_TIME Data Movement Rules |
| Name | Type | Rule Text/Value |
| DEF_END_TIME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Default End Time |
NO | ||
| Logical User Profile Default End Time |
NO | ||
| Logical User Profile Default End Time |
NO | ||
| EXPRESS (Oracle) USER_PROF DEF_END_TIME |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE DEF_END_TIME |
NO | ||
| PRPSL (Oracle) USER_PROFILE DEF_END_TIME |
NO | ||
| SMPL (Oracle) USER_PROFILE DEF_END_TIME |
NO |
| DEF_END_TIME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_END_TIME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_END_TIME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_END_TIME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ROW_PAGE_NBR |
| Base Object | USER_PROF |
| Attribute Name | Row Page Number |
| ColumnName | ROW_PAGE_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ROW_PAGE_NBR Column Properties |
| Datatype | NUMBER(5, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ROW_PAGE_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| ROW_PAGE_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ROW_PAGE_NBR Security Types |
| Name | Current Value |
| ROW_PAGE_NBR Bound Attachments |
| Name | Current Value |
| ROW_PAGE_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| ROW_PAGE_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Row Page Number |
NO | ||
| Logical User Profile Row Page Number |
NO | ||
| Logical User Profile Row Page Number |
NO | ||
| EXPRESS (Oracle) USER_PROF ROW_PAGE_NBR |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE ROW_PAGE_NBR |
NO | ||
| PRPSL (Oracle) USER_PROFILE ROW_PAGE_NBR |
NO | ||
| SMPL (Oracle) USER_PROFILE ROW_PAGE_NBR |
NO |
| ROW_PAGE_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ROW_PAGE_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ROW_PAGE_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ROW_PAGE_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IMP_PERSON_ID |
| Base Object | USER_PROF |
| Attribute Name | Person Identifier |
| ColumnName | IMP_PERSON_ID |
| Logical Rolename | Impersonate Person Identifier |
| RoleName | IMP_PERSON_ID |
| Domain | |
| Physical Only | NO |
| Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
| Note |
| IMP_PERSON_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| IMP_PERSON_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| IMP_PERSON_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IMP_PERSON_ID Security Types |
| Name | Current Value |
| IMP_PERSON_ID Bound Attachments |
| Name | Current Value |
| IMP_PERSON_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| IMP_PERSON_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Person Identifier |
NO | ||
| Logical User Profile Person Identifier |
NO | ||
| Logical User Profile Person Identifier |
NO | ||
| EXPRESS (Oracle) USER_PROF IMP_PERSON_ID |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE PERSON_ID |
NO | ||
| PRPSL (Oracle) USER_PROFILE PERSON_ID |
NO | ||
| SMPL (Oracle) USER_PROFILE IMP_PERSON_ID |
NO |
| IMP_PERSON_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IMP_PERSON_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IMP_PERSON_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IMP_PERSON_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SCHED_HR_IND |
| Base Object | USER_PROF |
| Attribute Name | Schedule by Hour Indicator |
| ColumnName | SCHED_HR_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| SCHED_HR_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SCHED_HR_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SCHED_HR_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| SCHED_HR_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 |
| SCHED_HR_IND Security Types |
| Name | Current Value |
| SCHED_HR_IND Bound Attachments |
| Name | Current Value |
| SCHED_HR_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SCHED_HR_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Schedule by Hour Indicator |
NO | ||
| Logical User Profile Schedule by Hour Indicator |
NO | ||
| Logical User Profile Schedule by Hour Indicator |
NO | ||
| EXPRESS (Oracle) USER_PROF SCHED_HR_IND |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE SCHED_HR_IND |
NO | ||
| PRPSL (Oracle) USER_PROFILE SCHED_HR_IND |
NO | ||
| SMPL (Oracle) USER_PROFILE SCHED_HR_IND |
NO |
| SCHED_HR_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SCHED_HR_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SCHED_HR_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SCHED_HR_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_STAT_IND |
| Base Object | USER_PROF |
| Attribute Name | Beam Status Indicator |
| ColumnName | BEAM_STAT_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| BEAM_STAT_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BEAM_STAT_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| BEAM_STAT_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| BEAM_STAT_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 |
| BEAM_STAT_IND Security Types |
| Name | Current Value |
| BEAM_STAT_IND Bound Attachments |
| Name | Current Value |
| BEAM_STAT_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| BEAM_STAT_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Beam Status Indicator |
NO | ||
| Logical User Profile Beam Status Indicator |
NO | ||
| Logical User Profile Beam Status Indicator |
NO | ||
| EXPRESS (Oracle) USER_PROF BEAM_STAT_IND |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE BEAM_STAT_IND |
NO | ||
| PRPSL (Oracle) USER_PROFILE BEAM_STAT_IND |
NO | ||
| SMPL (Oracle) USER_PROFILE BEAM_STAT_IND |
NO |
| BEAM_STAT_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_STAT_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_STAT_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_STAT_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTO_EMAIL_IND |
| Base Object | USER_PROF |
| Attribute Name | Automatic Email Indicator |
| ColumnName | AUTO_EMAIL_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| AUTO_EMAIL_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AUTO_EMAIL_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| AUTO_EMAIL_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| AUTO_EMAIL_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 |
| AUTO_EMAIL_IND Security Types |
| Name | Current Value |
| AUTO_EMAIL_IND Bound Attachments |
| Name | Current Value |
| AUTO_EMAIL_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| AUTO_EMAIL_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Automatic Email Indicator |
NO | ||
| Logical User Profile Automatic Email Indicator |
NO | ||
| Logical User Profile Automatic Email Indicator |
NO | ||
| EXPRESS (Oracle) USER_PROF AUTO_EMAIL_IND |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE AUTO_EMAIL_IND |
NO | ||
| PRPSL (Oracle) USER_PROFILE AUTO_EMAIL_IND |
NO | ||
| SMPL (Oracle) USER_PROFILE AUTO_EMAIL_IND |
NO |
| AUTO_EMAIL_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTO_EMAIL_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTO_EMAIL_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTO_EMAIL_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_INSTR_ID |
| Base Object | USER_PROF |
| Attribute Name | Instrument Identifier |
| ColumnName | DEF_INSTR_ID |
| Logical Rolename | Default Instrument Identifier |
| RoleName | DEF_INSTR_ID |
| Domain | |
| Physical Only | NO |
| Definition | Instrument Identifier: Abbreviated identier for the instrument. |
| Note |
| DEF_INSTR_ID Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DEF_INSTR_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| DEF_INSTR_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DEF_INSTR_ID Security Types |
| Name | Current Value |
| DEF_INSTR_ID Bound Attachments |
| Name | Current Value |
| DEF_INSTR_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| DEF_INSTR_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Instrument Identifier |
NO | ||
| Logical User Profile Instrument Identifier |
NO | ||
| Logical User Profile Instrument Identifier |
NO | ||
| EXPRESS (Oracle) USER_PROF DEF_INSTR_ID |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE DEF_INSTR_ID |
NO | ||
| PRPSL (Oracle) USER_PROFILE DEF_INSTR_ID |
NO | ||
| SMPL (Oracle) USER_PROFILE DEF_INSTR_ID |
NO |
| DEF_INSTR_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_INSTR_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_INSTR_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEF_INSTR_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PI_DISP_IND |
| Base Object | USER_PROF |
| Attribute Name | Principle Investigator Display Indicator |
| ColumnName | PI_DISP_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Principle Investigator Display Indicator: Indicates whether or not to display the PI name on the scheduling calendar next to the proposal run id. |
| Note |
| PI_DISP_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PI_DISP_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| PI_DISP_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| PI_DISP_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 |
| PI_DISP_IND Security Types |
| Name | Current Value |
| PI_DISP_IND Bound Attachments |
| Name | Current Value |
| PI_DISP_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| PI_DISP_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Principle Investigator Display Indicator |
NO | ||
| Logical User Profile Principle Investigator Display Indicator |
NO | ||
| Logical User Profile Principle Investigator Display Indicator |
NO | ||
| EXPRESS (Oracle) USER_PROF PI_DISP_IND |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE PI_DISP_IND |
NO | ||
| PRPSL (Oracle) USER_PROFILE PI_DISP_IND |
NO | ||
| SMPL (Oracle) USER_PROFILE PI_DISP_IND |
NO |
| PI_DISP_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PI_DISP_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PI_DISP_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PI_DISP_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| END_TIME_NEXT_DAY_IND |
| Base Object | USER_PROF |
| Attribute Name | End Time Next Day Indicator |
| ColumnName | END_TIME_NEXT_DAY_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| END_TIME_NEXT_DAY_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| END_TIME_NEXT_DAY_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| END_TIME_NEXT_DAY_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| END_TIME_NEXT_DAY_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 |
| END_TIME_NEXT_DAY_IND Security Types |
| Name | Current Value |
| END_TIME_NEXT_DAY_IND Bound Attachments |
| Name | Current Value |
| END_TIME_NEXT_DAY_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| END_TIME_NEXT_DAY_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile End Time Next Day Indicator |
NO | ||
| Logical User Profile End Time Next Day Indicator |
NO | ||
| Logical User Profile End Time Next Day Indicator |
NO | ||
| EXPRESS (Oracle) USER_PROF END_TIME_NEXT_DAY_IND |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE END_TIME_NEXT_DAY_IND |
NO | ||
| PRPSL (Oracle) USER_PROFILE END_TIME_NEXT_DAY_IND |
NO | ||
| SMPL (Oracle) USER_PROFILE END_TIME_NEXT_DAY_IND |
NO |
| END_TIME_NEXT_DAY_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| END_TIME_NEXT_DAY_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| END_TIME_NEXT_DAY_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| END_TIME_NEXT_DAY_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE_DISP_IND |
| Base Object | USER_PROF |
| Attribute Name | Title Display Indicator |
| ColumnName | TITLE_DISP_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| TITLE_DISP_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TITLE_DISP_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| TITLE_DISP_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| TITLE_DISP_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 |
| TITLE_DISP_IND Security Types |
| Name | Current Value |
| TITLE_DISP_IND Bound Attachments |
| Name | Current Value |
| TITLE_DISP_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| TITLE_DISP_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Title Display Indicator |
NO | ||
| Logical User Profile Title Display Indicator |
NO | ||
| Logical User Profile Title Display Indicator |
NO | ||
| EXPRESS (Oracle) USER_PROF TITLE_DISP_IND |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE TITLE_DISP_IND |
NO | ||
| PRPSL (Oracle) USER_PROFILE TITLE_DISP_IND |
NO | ||
| SMPL (Oracle) USER_PROFILE TITLE_DISP_IND |
NO |
| TITLE_DISP_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE_DISP_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE_DISP_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE_DISP_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_CONT_IND |
| Base Object | USER_PROF |
| Attribute Name | Local Contact Indicator |
| ColumnName | LOCAL_CONT_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| LOCAL_CONT_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LOCAL_CONT_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| LOCAL_CONT_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| LOCAL_CONT_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 |
| LOCAL_CONT_IND Security Types |
| Name | Current Value |
| LOCAL_CONT_IND Bound Attachments |
| Name | Current Value |
| LOCAL_CONT_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| LOCAL_CONT_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Profile Local Contact Indicator |
NO | ||
| Logical User Profile Local Contact Indicator |
NO | ||
| Logical User Profile Local Contact Indicator |
NO | ||
| EXPRESS (Oracle) USER_PROF LOCAL_CONT_IND |
NO | ||
| IPTSv5 (Oracle) USER_PROFILE LOCAL_CONT_IND |
NO | ||
| PRPSL (Oracle) USER_PROFILE LOCAL_CONT_IND |
NO | ||
| SMPL (Oracle) USER_PROFILE LOCAL_CONT_IND |
NO |
| LOCAL_CONT_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_CONT_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_CONT_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_CONT_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |