JOB_CURR_EFF_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
6	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
7	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
8	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
9	APPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers. 0=Core Appointment 1=Japan Kenmu Appointment 2=French Public Sector Appt 3=Staffing Default Value: 0
10	MAIN_APPT_NUM_JPN	Number(3,0)	SMALLINT NOT NULL	Tracks the empl_rcd for the Main Appointment of this row. For a Main Appointment, this field stores the same value as the current empl_rcd, for an Additional Appointment, it stores the value of a different empl_rcd.
11	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data Y/N Table Edit Default Value: N
12	POSN_CHANGE_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Position Management Record Y/N Table Edit Default Value: N
13	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration Default Value: A
14	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
15	ACTION_DT	Date(10)	DATE	Action Date Default Value: %date
16	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
17	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
18	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code Prompt Table: %RECNAME_EDIT
19	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
20	DEPT_ENTRY_DT	Date(10)	DATE	Department Entry Date
21	POSITION_ENTRY_DT	Date(10)	DATE	Position Entry Date
22	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating Default Value: N
23	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary Default Value: R
24	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time Default Value: F
25	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
26	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
27	BAS_GROUP_ID	Character(3)	VARCHAR2(3) NOT NULL	Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program. Prompt Table: BAS_GROUP_TBL
28	ELIG_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
29	ELIG_CONFIG2	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
30	ELIG_CONFIG3	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
31	ELIG_CONFIG4	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
32	ELIG_CONFIG5	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
33	ELIG_CONFIG6	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
34	ELIG_CONFIG7	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
35	ELIG_CONFIG8	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
36	ELIG_CONFIG9	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
37	BEN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated. A=Active D=Deceased L=Leave of Absence P=Leave With Benefits Q=Retired With Benefits R=Retired S=Suspended T=Terminated U=Terminated With Benefits
38	BAS_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.
39	COBRA_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
40	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried Prompt Table: PAYGRP_EMPLTYPE
41	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule Prompt Table: HOLIDAY_VW
42	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours Default Value: INSTALLATION.STD_HRS_DEFAULT
43	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period Default Value: INSTALLATION.STD_HRS_FREQUENCY Prompt Table: STDHRS_FREQ_VW
44	OFFICER_CD	Character(1)	VARCHAR2(1) NOT NULL	Officer Code C=Chairman D=Director N=None O=Officer P=President S=Secretary T=Treasurer V=Vice President Default Value: N
45	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification Prompt Table: EMPL_CLASS_TBL Set Control Field: REG_REGION
46	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Prompt Table: SAL_PLAN_TBL
47	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Prompt Table: SAL_GRADE_TBL
48	GRADE_ENTRY_DT	Date(10)	DATE	Grade Entry Date
49	STEP	Number(2,0)	SMALLINT NOT NULL	Step Prompt Table: SAL_STEP_TBL
50	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
51	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
52	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: %EDITTABLE2
53	EARNS_DIST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Earnings Distribution Type A=By Amount H=By Hours N=None P=By Percent Default Value: N
54	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Default Value: INSTALLATION.COMP_FREQUENCY Prompt Table: COMP_FREQ_VW
55	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
56	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
57	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
58	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
59	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
60	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
61	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
62	ANNL_BENEF_BASE_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
63	SHIFT_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Shift Differential Rate
64	SHIFT_FACTOR	Number(5,3)	DECIMAL(4,3) NOT NULL	Shift Differential Factor
65	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
66	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUSUNIT_HR_VW
67	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID Default Value: OPR_DEF_TBL_HR.SETID
68	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID Default Value: OPR_DEF_TBL_HR.SETID
69	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
70	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
71	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Default Value: OPR_DEF_TBL_HR.REG_REGION Prompt Table: REG_STANDARD_VW
72	DIRECTLY_TIPPED	Character(1)	VARCHAR2(1) NOT NULL	Tipped D=Directly Tipped I=Indirectly Tipped N=Not Tipped Default Value: JOBCODE_TBL.DIRECTLY_TIPPED
73	FLSA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FLSA Status field 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 Default Value: X
74	EEO_CLASS	Character(1)	VARCHAR2(1) NOT NULL	EEO Classification E=Exclude from Count N=None of the Above P=Production Trainee W=White-Collar Trainee Default Value: N
75	FUNCTION_CD	Character(2)	VARCHAR2(2) NOT NULL	Function Code Prompt Table: FUNCTION_CD_TBL
76	TARIFF_GER	Character(2)	VARCHAR2(2) NOT NULL	Tariff 01=Metal Processing 02=Banking 03=Building and Civil Engineering 04=Clothing Industry 05=Chemical Industry 06=Printing Industry 07=Retail Trade 08=Fossil Oil and Gas Extraction 09=Glass Industry 10=Wholesale and Foreign Trade 11=Wood Processing 12=Rubber Processing 13=Ceramics 14=Agriculture 15=Leather Processing 16=Public Sector 17=Paper Industry 18=Paper Processing 19=Sawing Industry 20=German Seaports 21=Hard-Coal Mining 22=Textile Industry 23=Insurance 24=Housing Industry 25=Periodical Publishers 26=Newspaper Publishers 27=Tobacco Industry
77	TARIFF_AREA_GER	Character(3)	VARCHAR2(3) NOT NULL	Tariff Area Prompt Table: TARIFF_AREA_GER
78	PERFORM_GROUP_GER	Character(2)	VARCHAR2(2) NOT NULL	Performance Group A1=Blue Collar Performance Grp. 1 A2=Blue Collar Performance Grp. 2 A3=Blue Collar Performance Grp. 3 K1=Commercial White Collar Grp. 1 K2=Commercial White Collar Grp. 2 K3=Commercial White Collar Grp. 3 K4=Commercial White Collar Grp. 4 K5=Commerical White Collar Grp. 5 T1=Technical White Collar Grp. 1 T2=Technical White Collar Grp. 2 T3=Technical White Collar Grp. 3 T4=Technical White Collar Grp. 4 T5=Technical White Collar Grp. 5
79	LABOR_TYPE_GER	Character(1)	VARCHAR2(1) NOT NULL	Labor Type M=Management N=Non-Management
80	SPK_COMM_ID_GER	Character(9)	VARCHAR2(9) NOT NULL	Spokesmen Committee ID Prompt Table: SPK_COMM_GER
81	HOURLY_RT_FRA	Character(3)	VARCHAR2(3) NOT NULL	Hours Type Prompt Table: HOURS_TYPE_FRA
82	ACCDNT_CD_FRA	Character(1)	VARCHAR2(1) NOT NULL	Work Accident Type Code 0=Do not Pay 1=Building 2=Waterproofing 3=Floor Surface 4=Factory Making 5=Laboratory 6=WorkShop 7=Office
83	VALUE_1_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 1
84	VALUE_2_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 2
85	VALUE_3_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 3
86	VALUE_4_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 4
87	VALUE_5_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 5
88	CTG_RATE	Number(3,0)	SMALLINT NOT NULL	Category Rate
89	PAID_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Paid Hours
90	PAID_FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field is si;ilqr to JOB.FTE field however it is computed with PAID_HOURS instead of STD_HOURS. It is a French specific field.
91	PAID_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Paid Work Period Prompt Table: STDHRS_FREQ_VW
92	UNION_FULL_PART	Character(1)	VARCHAR2(1) NOT NULL	Union Participation F=Full Time P=Part Time
93	UNION_POS	Character(1)	VARCHAR2(1) NOT NULL	Union Position L=Leader of the union N=National Leader R=Registered S=Leader of S.O.C.
94	MATRICULA_NBR	Number(5,0)	INTEGER NOT NULL	Matricula Number
95	SOC_SEC_RISK_CODE	Character(3)	VARCHAR2(3) NOT NULL	Occupation Code Prompt Table: %EDITTABLE12
96	UNION_FEE_AMOUNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Union Fee Amount
97	UNION_FEE_START_DT	Date(10)	DATE	Union Fee Start Date
98	UNION_FEE_END_DT	Date(10)	DATE	Union Fee End Date
99	EXEMPT_JOB_LBR	Character(1)	VARCHAR2(1) NOT NULL	Exempted Y/N Table Edit Default Value: N
100	EXEMPT_HOURS_MONTH	Number(3,0)	SMALLINT NOT NULL	Exempted Hours per Month
101	WRKS_CNCL_FUNCTION	Character(1)	VARCHAR2(1) NOT NULL	Works Council Function M=Member P=President S=Secretary
102	INTERCTR_WRKS_CNCL	Character(1)	VARCHAR2(1) NOT NULL	InterCtr.Works Cnil Function 1=Member 1 2=Member 2 3=Member 3
103	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
104	PAY_UNION_FEE	Character(1)	VARCHAR2(1) NOT NULL	Pay Union Fee Y/N Table Edit Default Value: N
105	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code Prompt Table: UNION_TBL
106	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2 Prompt Table: HR_BARG_UNIT
107	UNION_SENIORITY_DT	Date(10)	DATE	Union Seniority Date
108	ENTRY_DATE	Date(10)	DATE	Date Entered
109	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement Prompt Table: HR_LABOR_AGRMNT
110	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category Prompt Table: EMPL_CTG_L1_VW
111	EMPL_CTG_L1	Character(6)	VARCHAR2(6) NOT NULL	Employee Subcategory Prompt Table: EMPL_CTG_L2_VW
112	EMPL_CTG_L2	Character(6)	VARCHAR2(6) NOT NULL	Employee Subcategory 2 Prompt Table: EMPL_CTG_L3_VW
113	SETID_LBR_AGRMNT	Character(5)	VARCHAR2(5) NOT NULL	Labor Agreement SetID
114	WPP_STOP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N Flag to indicated that Wage Progression is stopped on this Assignment. Y/N Table Edit Default Value: N
115	LABOR_FACILITY_ID	Character(10)	VARCHAR2(10) NOT NULL	Labor Facility ID Prompt Table: HR_LBR_FAC_VW
116	LBR_FAC_ENTRY_DT	Date(10)	DATE	Date the Person was added to this Labor Facility.
117	LAYOFF_EXEMPT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N Flag to indicate if a Person's Assignment is exempt from Layoff. Y/N Table Edit Default Value: N
118	LAYOFF_EXEMPT_RSN	Character(11)	VARCHAR2(11) NOT NULL	Reason for the Exemption from Layoff Prompt Table: HR_LAY_EXEM_TBL
119	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: %EDITTABLE6
120	GP_DFLT_ELIG_GRP	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level) Y/N Table Edit Default Value: Y
121	GP_ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	Eligibility Group Prompt Table: GP_ELIG_GRP
122	GP_DFLT_CURRTTYP	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level) Y/N Table Edit Default Value: Y
123	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
124	GP_DFLT_EXRTDT	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level) Y/N Table Edit Default Value: Y
125	GP_ASOF_DT_EXG_RT	Character(1)	VARCHAR2(1) NOT NULL	This field is used as a flag to determine whether to use a default exchange rate or not. B=Pay Period Begin Date E=Pay Period End Date P=Payment Date
126	ADDS_TO_FTE_ACTUAL	Character(1)	VARCHAR2(1) NOT NULL	Adds to FTE Actual Count Y/N Table Edit Default Value: N
127	CLASS_INDC	Character(1)	VARCHAR2(1) NOT NULL	Classified/Unclassified Indc B=All C=Classified T=Temporary U=Unclassified Default Value: C
128	ENCUMB_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Encumbrance Override Y/N Table Edit Default Value: N
129	FICA_STATUS_EE	Character(1)	VARCHAR2(1) NOT NULL	FICA Status-Employee E=Exempt H=ER FICA Exmpt M=Medicare only N=Subject
130	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
131	PRORATE_CNT_AMT	Character(1)	VARCHAR2(1) NOT NULL	Prorate Contract Change Amount C=Prorate Over Contract Period N=No Proration of Change Amt. P=Prorate over Payment Period Default Value: N
132	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface Default Value: OPR_DEF_TBL_HR.PAY_SYSTEM_FLG
133	BORDER_WALKER	Character(1)	VARCHAR2(1) NOT NULL	Cross Border Worker Y/N Table Edit Default Value: N
134	LUMP_SUM_PAY	Character(1)	VARCHAR2(1) NOT NULL	Lump Sum Retro Payment Y/N Table Edit Default Value: N
135	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number Prompt Table: CNT_ACTIVE_VW
136	JOB_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned. N=Not Applicable P=Primary Job S=Secondary Job Default Value: P
137	WRKS_CNCL_ROLE_CHE	Character(30)	VARCHAR2(30) NOT NULL	Work Council Role
138	BENEFIT_SYSTEM	Character(2)	VARCHAR2(2) NOT NULL	A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits. BA=Benefits Administration BN=Base Benefits OT=Not Managed in PeopleSoft
139	WORK_DAY_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Number of Hours in a Work Day
140	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID Prompt Table: PERSON_NAME
141	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number Prompt Table: POSITION_DATA
142	FORCE_PUBLISH	Date(10)	DATE	Used to Force a publish on a row of data that wouldn't otherwise have been changed. This field is a system field only and will not appear on any Page so it does not need to be translated.
143	JOB_DATA_SRC_CD	Character(3)	VARCHAR2(3) NOT NULL	This field indicates the source of a job row ie. whether the job row was User Generated (ie. online), Batch Generated, Staff Movement generated, etc. A blank in this field implies that the job row is user generated. 000=User Generated 001=Batch Generated 002=Staff Movement Generated
144	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: %EDITTABLE3
145	REHIRE_DT	Date(10)	DATE	Rehire Date
146	HIRE_DT	Date(10)	DATE	First Start Date
147	LAST_HIRE_DT	Date(10)	DATE	Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
148	TERMINATION_DT	Date(10)	DATE	Termination Date