EMPLIDEMPL_RCDDefault Value: 0
EFFDTDefault Value: %date
EFFSEQTRACKING_SEQDefault Value: 1
Prompt Table: MIL_APPRVL_LVL
Prompt Table: PSOPRDEFN_VW
Y/N Table Edit
Prompt Table: MIL_ORD_CD_TBL
1=On-line
2=Mass Update
3=Other
MIL_EE_DATA_TRK(SQL Table) |
Index Back |
|---|---|
Employee Approval trackingThis record captures all the approvals associated with changing a military employee's job record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: 0 |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | TRACKING_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Tracking Sequence
Default Value: 1 |
| 6 | MIL_APPRVL_LVL | Character(10) | VARCHAR2(10) NOT NULL |
Military Approval Level
Prompt Table: MIL_APPRVL_LVL |
| 7 | APPROVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Approver Oper ID
Prompt Table: PSOPRDEFN_VW |
| 8 | MIL_OVRRD_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Operator Overriding the Approval
Y/N Table Edit |
| 9 | APPRVL_DT | Date(10) | DATE | Approval Date |
| 10 | MIL_ORDER_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Military Order Code
Prompt Table: MIL_ORD_CD_TBL |
| 11 | MIL_UPD_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Source of Update for Approval Tracking Transaction
1=On-line 2=Mass Update 3=Other |
| 12 | MU_ID | Character(15) | VARCHAR2(15) NOT NULL | Mass Update ID |
| 13 | COMMENTS | Long Character | CLOB | Comment |