OSP PROPOSAL PERSONS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FACULTY_FLAG |
Flag identifying whether or not an employee is a member of the faculty (yes or no). |
VARCHAR2 |
1 |
OSP_PROPOSAL_KEY |
XXX |
VARCHAR2 |
8 |
OSP_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
8 |
PERSON_ID |
XXX |
VARCHAR2 |
40 |
PERSON_NAME |
XXX |
VARCHAR2 |
90 |
PERSON_PROJECT_ROLE |
XXX |
VARCHAR2 |
60 |
PERSON_ROLE |
XXX |
VARCHAR2 |
12 |
ROLODEX_ID |
XXX |
NUMBER |
|
SEQUENCE_NUMBER |
Numerical value identifying the position of this record for the person. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |