| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
ACTION_DT_SS |
Date(10) |
DATE |
Termination Date
|
| 3 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 4 |
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
|
| 5 |
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. */
|
| 6 |
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
|
| 7 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
|
| 8 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
|
| 9 |
ORIGINATORID |
Character(30) |
VARCHAR2(30) NOT NULL |
Originator Identifier
|
| 10 |
TRANSACTION_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
EDI Transaction Name
|
| 11 |
UPD_BY_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 12 |
UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 13 |
MANUAL_UPD_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 14 |
MANUAL_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 15 |
SS_STAT_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
A=Approved
B=CI failed - Errors & Warnings
C=Cancelled
D=Denied
E=Errors Encountered
I=In Approval Process
M=Administrator Action Required
S=Success
W=Warnings Encountered
Default Value: I
|
| 16 |
SS_WARNING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
Y/N Table Edit
Default Value: N
|
| 17 |
SS_FUTURE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
Y/N Table Edit
Default Value: N
|
| 18 |
APPROVAL_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
N=No Approval Required
Y=Approval Required
|