FPY_JCD_STG_TBL

(SQL Table)
 Index Back

Job Code Staging table

Job Code Staging table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FPY_SETID Character(50) VARCHAR2(50) NOT NULL Setid
2 FPY_JOB_ID Number(18,0) DECIMAL(18) NOT NULL Job ID
3 FPY_START_DTTM Character(50) VARCHAR2(50) NOT NULL Start Date Time
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
6 FPY_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL FPY_PROC_MARKER
7 FPY_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL FPY Error Flag
N=No
Y=Yes
8 FPY_MODE Character(1) VARCHAR2(1) NOT NULL FPY_MODE
9 FPY_JOB_CI Character(1) VARCHAR2(1) NOT NULL FPY_JOB_CI
10 FPY_PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Processed Flag
11 FPY_BYPASS_FLG Character(1) VARCHAR2(1) NOT NULL Bypass Flag
12 FPY_ERR_CORR_REQD Character(1) VARCHAR2(1) NOT NULL Correction Required
N=No
Y=Yes
13 FPY_BUS_OBJ Character(3) VARCHAR2(3) NOT NULL Business Object
ABS=Absence
ADD=Person Address
ALL=All
BNS=Bonus
BUS=Business Unit
CCI=Company
CMP=Compensation Data
COM=Company
DCI=Department
DEP=Department
EML=Person Email
JCD=JobCode
JCI=Job Data
JOB=Job Data
LCI=Location
LEG=Person Legislative Data
LOC=Location
NAM=Person Name
NID=Person National Identifier
OCI=JobCode
ORG=Organisation Instance
PCI=Person
PER=Person
PHN=Person Phone
POS=Position
SCI=Position
14 FPY_EFF_END_DT Character(50) VARCHAR2(50) NOT NULL Effective End Date
15 FPY_STD_HRS_FREQ Character(120) VARCHAR2(120) NOT NULL Standard Hrs Frequency
16 FPY_DESCR Long Character CLOB Description
17 FPY_MANAGER_LEVEL Character(120) VARCHAR2(120) NOT NULL Manager Level
18 FPY_REG_TEMP Character(120) VARCHAR2(120) NOT NULL Reg Temp
19 FPY_EFF_STATUS Character(120) VARCHAR2(120) NOT NULL Active Status
20 FPY_FULL_PART_TIME Character(120) VARCHAR2(120) NOT NULL Full /Part Time
21 FPY_FLSA_STATUS Long Character(600) VARCHAR2(600) FLSA_STATUS
22 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description
23 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
24 SETID Character(5) VARCHAR2(5) NOT NULL SetID
25 DESCR Character(30) VARCHAR2(30) NOT NULL Description
26 MED_CHKUP_REQ Character(1) VARCHAR2(1) NOT NULL Medical Checkup Required
27 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
28 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
29 DIRECTLY_TIPPED Character(1) VARCHAR2(1) NOT NULL Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
30 ELS_STATUS Character(1) VARCHAR2(1) NOT NULL Employment and Labour Standards Status
1=Exempt
2=Non-Exempt
31 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
32 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
33 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
34 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager
35 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
36 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required