| # |
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 Rcd Nbr
|
| 3 |
ACTION_DT_SS |
Date(10) |
DATE |
* Effective Date
Default Value: %Date
|
| 4 |
TRANS_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 6 |
MAR_STATUS_DT |
Date(10) |
DATE |
This is the date that the employee's Marital status is/was effective.
/* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons.
1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user.
2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
|
| 7 |
TRANSACTION_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
EDI Transaction Name
|
| 8 |
WF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
|
| 9 |
UPD_BY_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 10 |
UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 11 |
ORIGINATOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Originator's ID
|
| 12 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
|
| 13 |
GVT_LEG_AUTH_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (1)
|
| 14 |
GVT_LEG_AUTH_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (2)
|
| 15 |
GVT_SF50_REMARK |
Character(3) |
VARCHAR2(3) NOT NULL |
SF50 Remark Code
|
| 16 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 17 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
Set Control Field: DESCR
|
| 18 |
FE_SS_STAT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on "_DAT" records for 8.3 eFed Workflow Enhancements
A=Administrator Action Required
B=CI failed - Errors & Warnings
C=Cancelled
D=Denied
E=Error with CI or Appr Chain
I=In Approval Process
M=Manually Entered into PAR
P=Automatically Sent to PAR
S=Completed
W=Warnings Encountered
|
| 19 |
FE_SS_FUTURE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Future Flag
Y/N Table Edit
|
| 20 |
MANUAL_UPD_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 21 |
MANUAL_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Used on "_DAT" records for 8.3 Workflow Enhancements
|