| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSON.EMPLID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
ACTION_DT_SS |
Date(10) |
DATE NOT NULL |
Termination Date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
HR_MSS_CT_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
Compound Transaction Name
|
| 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
Prompt Table:
ACTION_TBL
|
| 8 |
ACTION_REASON_SS |
Character(3) |
VARCHAR2(3) NOT NULL |
Action Reason field for use on Self Service panels.
Prompt Table:
ACTN_REASON_TBL
Set Control Field: ACTION
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUSUNIT_HR_VW2
|
| 10 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
HR_GSS_POSN_VW
|
| 11 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 12 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 13 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 14 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
Prompt Table:
HR_GSS_ACTV_DVW
|
| 15 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
Reports To Position Number
Prompt Table:
POSN_SRCH_GSS
|
| 16 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
Default Value: F
|
| 17 |
ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Annual Rate
|
| 18 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 19 |
POSITION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Flag
N=No
Y=Yes
|
| 20 |
UPDATE_POSN_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Position Data
Default Value: N
|
| 21 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 22 |
FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
This field represent Full Time Equivalence
|
| 23 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last Date Worked
|
| 24 |
LDW_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether the user has overridden the Last Date Worked - ON THIS JOB_DATES row. It will only be set to 'Y' on the row where the date is entered, it will be 'N' on the later rows.
This allows us to identify which JOB_DATES row is the row where the Date was either set or updated without having to look at the previous row. If the LDW = ( EFFDT - 1 ) or the LDW_OVR is 'Y', then this is the row where the LDW was set - and therefore can be corrected.
Y/N Table Edit
Default Value: N
|
| 25 |
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
|
| 26 |
REQUEST_DT |
Date(10) |
DATE |
Request Date
Default Value: %Date
|
| 27 |
EXPECTED_RETURN_DT |
Date(10) |
DATE |
Expected Return Date
|
| 28 |
ORIGINATORID |
Character(30) |
VARCHAR2(30) NOT NULL |
Originator Identifier
|
| 29 |
TRANSACTION_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
EDI Transaction Name
|
| 30 |
UPD_BY_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 31 |
UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 32 |
MANUAL_UPD_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 33 |
MANUAL_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Used on "_DAT" records for 8.3 Workflow Enhancements
|
| 34 |
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
|
| 35 |
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
|
| 36 |
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
|