OSP RCR TRAINING NEEDED Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
100 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
100 |
PAYROLL_DIST_AMOUNT |
The amount distributed for the specified parameters (cost collector, time period, etc) for a position/person/percent/and cost object |
NUMBER |
28,7 |
PAYROLL_FOR_PERIOD_KEY |
Key field used to join the PAYROLL_FOR_PERIOD table to Payroll fact tables. Use for joining data, not for reporting. |
VARCHAR2 |
8 |
PAYROLL_PAYMENT_DATE |
The date that appears on the check or direct deposit as the payment date. |
DATE |
|
PERSON_ID |
XXX |
VARCHAR2 |
9 |
POSITION_TITLE |
Specific Position Title tied to the Position ID. This may be more specifc than the official job title. |
VARCHAR2 |
40 |
PROFIT_CENTER_NAME |
The text name of the profit center. |
VARCHAR2 |
40 |
PROJECT_WBS_EFFECTIVE_DATE |
Begin date of the work breakdown structure for this project. |
DATE |
|
PROJECT_WBS_EXPIRATION_DATE |
End date of the work breakdown structure for this project. |
DATE |
|
PROJECT_WBS_ID |
Project work breakdown structure element identifier. |
VARCHAR2 |
7 |
SUPERVISOR |
The name of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
30 |
TIME_LAPSE |
XXX |
NUMBER |
28,7 |
TRAINING_COMPLETED_DATE |
XXX |
VARCHAR2 |
18 |
TRAINING_COMPLETED_FLAG |
XXX |
NUMBER |
28,7 |
TRAINING_DUE_DATE |
XXX |
DATE |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |