Proposal Identifier |
Base Entity | Proposal Funding Agency |
Attribute Name | Proposal Identifier |
Logical Rolename | |
ColumnName | PRPSL_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Proposal Identifier: Unique identifer assigned to the proposal. |
Note |
Proposal Identifier Logical Attribute Properties |
Logical Attribute Name | Proposal Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Proposal Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Proposal Identifier Security Types |
Name | Current Value |
Proposal Identifier Bound Attachments |
Name | Current Value |
Proposal Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Proposal Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Funding Agency Proposal Identifier |
NO | ||
CNMS_PRPSL (Oracle) PRPSL_FUND_AGCY PRPSL_ID |
NO |
Proposal Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Funding Status Identifier |
Base Entity | Proposal Funding Agency |
Attribute Name | Funding Status Identifier |
Logical Rolename | |
ColumnName | FUND_STAT_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Funding Status Identifier Logical Attribute Properties |
Logical Attribute Name | Funding Status Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | NO |
Funding Status Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Funding Status Identifier Security Types |
Name | Current Value |
Funding Status Identifier Bound Attachments |
Name | Current Value |
Funding Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Funding Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Funding Agency Funding Status Identifier |
NO | ||
CNMS_PRPSL (Oracle) PRPSL_FUND_AGCY FUND_STAT_ID |
NO |
Funding Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Funding Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Funding Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Funding Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Funding Agency |
Base Entity | Proposal Funding Agency |
Attribute Name | Funding Agency |
Logical Rolename | |
ColumnName | FUND_AGENCY |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Funding Agency Logical Attribute Properties |
Logical Attribute Name | Funding Agency |
Datatype | VARCHAR(255) |
Nullable | NO |
Funding Agency Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Funding Agency Security Types |
Name | Current Value |
Funding Agency Bound Attachments |
Name | Current Value |
Funding Agency Data Movement Rules |
Name | Type | Rule Text/Value |
Funding Agency Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Funding Agency Funding Agency |
NO | ||
CNMS_PRPSL (Oracle) PRPSL_FUND_AGCY FUND_AGENCY |
NO |
Funding Agency Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Funding Agency Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Funding Agency Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Funding Agency Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Decision Date |
Base Entity | Proposal Funding Agency |
Attribute Name | Decision Date |
Logical Rolename | |
ColumnName | DECN_DTE |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Decision Date Logical Attribute Properties |
Logical Attribute Name | Decision Date |
Datatype | DATE |
Nullable | YES |
Decision Date Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Decision Date Security Types |
Name | Current Value |
Decision Date Bound Attachments |
Name | Current Value |
Decision Date Data Movement Rules |
Name | Type | Rule Text/Value |
Decision Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Funding Agency Decision Date |
NO | ||
CNMS_PRPSL (Oracle) PRPSL_FUND_AGCY DECN_DTE |
NO |
Decision Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Decision Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Decision Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Decision Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |