Share this page
BRIDAGE_PROPOSALS_MANAGERS
This table stores all the relationship between proposals and person.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
DIM_ PROPOSALS |
PROPOSAL_ID |
PK_ PROPOSALS_ID |
|
DIM_PERSON |
PROP_PROJECT_MANAGER_ID |
PK_ PERSON_ID |
|
DIM_PERSON |
PROP_BENEFIT_MANAGER_ID |
PK_ PERSON_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
SCD2 |
|---|---|---|---|---|
|
PK_PROPOSAL_MANAGERS_ID |
Nullable |
INT |
System-generated identifier
|
No |
|
MD_BUSINESS_KEY |
Nullable |
VARCHAR (1000) |
Primary key that is mapped to one or more source columns
|
No |
|
MD_ENTERPRISE_KEY |
Nullable |
INT |
Unique identifier for entity |
No |
|
PROPOSAL_ID |
Nullable |
INT |
Unique identifier for proposals |
No |
|
PROPOSAL_ENTERPRISE_KEY |
Nullable |
VARCHAR (1000) |
Foreign key that is mapped to DIM_ PROPOSALS
|
No |
|
PROPOSAL_BUSINESS_KEY |
Nullable |
INT |
Unique identifier for foreign key
|
No |
|
PROP_PROJECT_MANAGER_ID |
Nullable |
INT |
Unique identifier for its project manager |
No |
|
PROP_PROJECT_MANAGER_BUSINESS_ KEY |
Nullable |
VARCHAR (1000) |
Foreign key that is mapped to DIM_ PERSON
|
No |
|
PROP_PROJECT_MANAGER_ ENTERPRISE_KEY |
Nullable |
INT |
Unique identifier for foreign key
|
No |
|
PROP_BENEFIT_MANAGER_ID |
Nullable |
INT |
Unique identifier for its benefit manager |
No |
|
PROP_BENEFIT_MANAGER_BUSINESS_ KEY |
Nullable |
VARCHAR (1000) |
Foreign key that is mapped to DIM_ PERSON
|
No |
|
PROP_BENEFIT_MANAGER_ ENTERPRISE_KEY |
Nullable |
INT |
Unique identifier for foreign key
|
No |
|
MD_BATCH_ID |
Nullable |
INT |
ID of data batch |
No |
|
MD_PROCESS_ID |
Nullable |
INT |
ID of ETL process running on a specific task |
No |
|
MD_SOURCE_INSTANCE_ID |
Nullable |
INT |
Content pack ID of source instance |
No |
|
MD_CREATEDDATE |
Nullable |
DATETIME |
Date of the record being inserted |
No |
|
MD_DELETEDDATE |
Nullable |
DATETIME |
Date of the record being deleted |
No |
|
MD_LASTMODDATE |
Nullable |
DATETIME |
Date of the record being updated |
No |
|
MD_TRANSLASTIND |
Nullable |
VARCHAR(1) |
Flags whether it is the latest record after updated by SCD2 |
No |
|
MD_TRANSENDDATE |
Nullable |
DATETIME |
End date of the record being effective |
No |
|
MD_ACTIVESTATUSIND |
Nullable |
VARCHAR(1) |
Flags whether or not the old record is deleted |
No |
|
MD_HASH_CODE_SCD1 |
Nullable |
VARCHAR(40) |
(Only for dimension table) Hash code that is generated by SCD1 columns |
No |
|
MD_HASH_CODE_SCD2 |
Nullable |
VARCHAR(40) |
(Only for dimension table) Hash code that is generated by SCD2 columns |
No |
Projections
This table uses no projections.
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
PROPOSAL_MANAGERS_ENTERPRISE_XREF_SEQ |
MD_ENTERPRISE_KEY |
|
PROPOSAL_MANAGERS_KEY_LOOKUP_SEQ |
PK_ PROPOSAL_MANAGERS_ID |
|
PROPOSALS_ENTERPRISE_XREF_SEQ |
PROPOSAL_ENTERPRISE_KEY |
|
PROPOSALS_KEY_LOOKUP_SEQ |
PROPOSAL_ID |
|
PERSON_ENTERPRISE_XREF_SEQ |
PERSON_ID |
|
PERSON_KEY_LOOKUP_SEQ |
PERSON_ID |
