| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUDGET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget ID
|
| 2 |
BUDGET_START_DT |
Date(10) |
DATE NOT NULL |
Budget Start Date
|
| 3 |
TREE_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal beginning node range number
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 6 |
VC_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
VC Plan ID
|
| 7 |
AUDIT_STAMP |
DateTime(26) |
TIMESTAMP NOT NULL |
Date and Time Stamp
|
| 8 |
AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 9 |
OPR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Operators Empl ID
|
| 10 |
WCS_P_AMT_ORIG |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Audit Original Employee Proposed Amount
|
| 11 |
WCS_P_AMT_NEW |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Audit New Employee Proposed Amount
|