PRPSL_ID |
Base Object | USER_ONSITE_DUMP |
Attribute Name | PRPSL_ID |
ColumnName | PRPSL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PRPSL_ID Column Properties |
Datatype | VARCHAR2(250) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PRPSL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 250 |
Percent Null | 0 |
PRPSL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PRPSL_ID Security Types |
Name | Current Value |
PRPSL_ID Bound Attachments |
Name | Current Value |
PRPSL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PRPSL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP PRPSL_ID |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP PRPSL_ID |
NO |
PRPSL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROPOSAL_TYPE |
Base Object | USER_ONSITE_DUMP |
Attribute Name | PROPOSAL_TYPE |
ColumnName | PROPOSAL_TYPE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PROPOSAL_TYPE Column Properties |
Datatype | VARCHAR2(20) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PROPOSAL_TYPE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
PROPOSAL_TYPE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PROPOSAL_TYPE Security Types |
Name | Current Value |
PROPOSAL_TYPE Bound Attachments |
Name | Current Value |
PROPOSAL_TYPE Data Movement Rules |
Name | Type | Rule Text/Value |
PROPOSAL_TYPE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP PROPOSAL_TYPE |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP PROPOSAL_TYPE |
NO |
PROPOSAL_TYPE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROPOSAL_TYPE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROPOSAL_TYPE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROPOSAL_TYPE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTRUMENT |
Base Object | USER_ONSITE_DUMP |
Attribute Name | INSTRUMENT |
ColumnName | INSTRUMENT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
INSTRUMENT Column Properties |
Datatype | VARCHAR2(20) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INSTRUMENT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
INSTRUMENT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INSTRUMENT Security Types |
Name | Current Value |
INSTRUMENT Bound Attachments |
Name | Current Value |
INSTRUMENT Data Movement Rules |
Name | Type | Rule Text/Value |
INSTRUMENT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP INSTRUMENT |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP INSTRUMENT |
NO |
INSTRUMENT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTRUMENT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTRUMENT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTRUMENT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FACILITY_RUN_CYCLE |
Base Object | USER_ONSITE_DUMP |
Attribute Name | FACILITY_RUN_CYCLE |
ColumnName | FACILITY_RUN_CYCLE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FACILITY_RUN_CYCLE Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FACILITY_RUN_CYCLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
FACILITY_RUN_CYCLE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FACILITY_RUN_CYCLE Security Types |
Name | Current Value |
FACILITY_RUN_CYCLE Bound Attachments |
Name | Current Value |
FACILITY_RUN_CYCLE Data Movement Rules |
Name | Type | Rule Text/Value |
FACILITY_RUN_CYCLE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP FACILITY_RUN_CYCLE |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP FACILITY_RUN_CYCLE |
NO |
FACILITY_RUN_CYCLE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FACILITY_RUN_CYCLE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FACILITY_RUN_CYCLE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FACILITY_RUN_CYCLE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_CYCLE |
Base Object | USER_ONSITE_DUMP |
Attribute Name | RUN_CYCLE |
ColumnName | RUN_CYCLE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
RUN_CYCLE Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RUN_CYCLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
RUN_CYCLE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RUN_CYCLE Security Types |
Name | Current Value |
RUN_CYCLE Bound Attachments |
Name | Current Value |
RUN_CYCLE Data Movement Rules |
Name | Type | Rule Text/Value |
RUN_CYCLE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP RUN_CYCLE |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP RUN_CYCLE |
NO |
RUN_CYCLE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_CYCLE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_CYCLE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_CYCLE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_START |
Base Object | USER_ONSITE_DUMP |
Attribute Name | RUN_START |
ColumnName | RUN_START |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
RUN_START Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RUN_START Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
RUN_START Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RUN_START Security Types |
Name | Current Value |
RUN_START Bound Attachments |
Name | Current Value |
RUN_START Data Movement Rules |
Name | Type | Rule Text/Value |
RUN_START Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP RUN_START |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP RUN_START |
NO |
RUN_START Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_START Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_START Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_START Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_END |
Base Object | USER_ONSITE_DUMP |
Attribute Name | RUN_END |
ColumnName | RUN_END |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
RUN_END Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RUN_END Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
RUN_END Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RUN_END Security Types |
Name | Current Value |
RUN_END Bound Attachments |
Name | Current Value |
RUN_END Data Movement Rules |
Name | Type | Rule Text/Value |
RUN_END Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP RUN_END |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP RUN_END |
NO |
RUN_END Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_END Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_END Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RUN_END Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
USER_NAME |
Base Object | USER_ONSITE_DUMP |
Attribute Name | USER_NAME |
ColumnName | USER_NAME |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
USER_NAME Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
USER_NAME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
USER_NAME Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
USER_NAME Security Types |
Name | Current Value |
USER_NAME Bound Attachments |
Name | Current Value |
USER_NAME Data Movement Rules |
Name | Type | Rule Text/Value |
USER_NAME Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP USER_NAME |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP USER_NAME |
NO |
USER_NAME Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
USER_NAME Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
USER_NAME Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
USER_NAME Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION |
Base Object | USER_ONSITE_DUMP |
Attribute Name | INSTITUTION |
ColumnName | INSTITUTION |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
INSTITUTION Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INSTITUTION Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
INSTITUTION Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INSTITUTION Security Types |
Name | Current Value |
INSTITUTION Bound Attachments |
Name | Current Value |
INSTITUTION Data Movement Rules |
Name | Type | Rule Text/Value |
INSTITUTION Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP INSTITUTION |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP INSTITUTION |
NO |
INSTITUTION Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PERSON_ID |
Base Object | USER_ONSITE_DUMP |
Attribute Name | PERSON_ID |
ColumnName | PERSON_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PERSON_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
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 USER_ONSITE_DUMP PERSON_ID |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP 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 |
BADGE |
Base Object | USER_ONSITE_DUMP |
Attribute Name | BADGE |
ColumnName | BADGE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BADGE Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BADGE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
BADGE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BADGE Security Types |
Name | Current Value |
BADGE Bound Attachments |
Name | Current Value |
BADGE Data Movement Rules |
Name | Type | Rule Text/Value |
BADGE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP BADGE |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP BADGE |
NO |
BADGE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BADGE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BADGE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BADGE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Base Object | USER_ONSITE_DUMP |
Attribute Name | |
ColumnName | |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EMAIL Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMAIL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
EMAIL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EMAIL Security Types |
Name | Current Value |
EMAIL Bound Attachments |
Name | Current Value |
EMAIL Data Movement Rules |
Name | Type | Rule Text/Value |
EMAIL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP |
NO |
EMAIL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOURCE |
Base Object | USER_ONSITE_DUMP |
Attribute Name | SOURCE |
ColumnName | SOURCE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SOURCE Column Properties |
Datatype | VARCHAR2(13) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SOURCE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 13 |
Percent Null | 0 |
SOURCE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SOURCE Security Types |
Name | Current Value |
SOURCE Bound Attachments |
Name | Current Value |
SOURCE Data Movement Rules |
Name | Type | Rule Text/Value |
SOURCE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP SOURCE |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP SOURCE |
NO |
SOURCE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOURCE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOURCE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOURCE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_COUNTRY |
Base Object | USER_ONSITE_DUMP |
Attribute Name | INSTITUTION_COUNTRY |
ColumnName | INSTITUTION_COUNTRY |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
INSTITUTION_COUNTRY Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INSTITUTION_COUNTRY Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
INSTITUTION_COUNTRY Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INSTITUTION_COUNTRY Security Types |
Name | Current Value |
INSTITUTION_COUNTRY Bound Attachments |
Name | Current Value |
INSTITUTION_COUNTRY Data Movement Rules |
Name | Type | Rule Text/Value |
INSTITUTION_COUNTRY Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP INSTITUTION_COUNTRY |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP INSTITUTION_COUNTRY |
NO |
INSTITUTION_COUNTRY Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_COUNTRY Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_COUNTRY Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_COUNTRY Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_STATE |
Base Object | USER_ONSITE_DUMP |
Attribute Name | INSTITUTION_STATE |
ColumnName | INSTITUTION_STATE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
INSTITUTION_STATE Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INSTITUTION_STATE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
INSTITUTION_STATE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INSTITUTION_STATE Security Types |
Name | Current Value |
INSTITUTION_STATE Bound Attachments |
Name | Current Value |
INSTITUTION_STATE Data Movement Rules |
Name | Type | Rule Text/Value |
INSTITUTION_STATE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP INSTITUTION_STATE |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP INSTITUTION_STATE |
NO |
INSTITUTION_STATE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_STATE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_STATE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_STATE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_TYPE |
Base Object | USER_ONSITE_DUMP |
Attribute Name | INSTITUTION_TYPE |
ColumnName | INSTITUTION_TYPE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
INSTITUTION_TYPE Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INSTITUTION_TYPE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
INSTITUTION_TYPE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INSTITUTION_TYPE Security Types |
Name | Current Value |
INSTITUTION_TYPE Bound Attachments |
Name | Current Value |
INSTITUTION_TYPE Data Movement Rules |
Name | Type | Rule Text/Value |
INSTITUTION_TYPE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP INSTITUTION_TYPE |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP INSTITUTION_TYPE |
NO |
INSTITUTION_TYPE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_TYPE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_TYPE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTITUTION_TYPE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID |
Base Object | USER_ONSITE_DUMP |
Attribute Name | FACIL_ID |
ColumnName | FACIL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FACIL_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FACIL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
FACIL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FACIL_ID Security Types |
Name | Current Value |
FACIL_ID Bound Attachments |
Name | Current Value |
FACIL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
FACIL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP FACIL_ID |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP FACIL_ID |
NO |
FACIL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FY |
Base Object | USER_ONSITE_DUMP |
Attribute Name | FY |
ColumnName | FY |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FY Column Properties |
Datatype | CHAR(4) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FY Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
FY Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FY Security Types |
Name | Current Value |
FY Bound Attachments |
Name | Current Value |
FY Data Movement Rules |
Name | Type | Rule Text/Value |
FY Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP FY |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP FY |
NO |
FY Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FY Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FY Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FY Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FY_START |
Base Object | USER_ONSITE_DUMP |
Attribute Name | FY_START |
ColumnName | FY_START |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FY_START Column Properties |
Datatype | CHAR(4) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FY_START Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
FY_START Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FY_START Security Types |
Name | Current Value |
FY_START Bound Attachments |
Name | Current Value |
FY_START Data Movement Rules |
Name | Type | Rule Text/Value |
FY_START Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP FY_START |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP FY_START |
NO |
FY_START Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FY_START Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FY_START Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FY_START Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FY_END |
Base Object | USER_ONSITE_DUMP |
Attribute Name | FY_END |
ColumnName | FY_END |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FY_END Column Properties |
Datatype | CHAR(4) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FY_END Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
FY_END Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FY_END Security Types |
Name | Current Value |
FY_END Bound Attachments |
Name | Current Value |
FY_END Data Movement Rules |
Name | Type | Rule Text/Value |
FY_END Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical USER_ONSITE_DUMP FY_END |
NO | ||
ENGA (Oracle) USER_ONSITE_DUMP FY_END |
NO |
FY_END Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FY_END Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FY_END Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FY_END Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |