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

Contnet 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