JOB_JR_CV

#	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 Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: 0
5	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %datetime
6	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	TAXCODE_UK	Character(15)	VARCHAR2(15) NOT NULL	Tax Code for the UK
8	TAX_BASIS_UK	Character(1)	VARCHAR2(1) NOT NULL	Tax Basis for the UK 0=Cumulative 1=Week 1/Month 1 Default Value: 0
9	WORKER_TYPE_MEX	Character(4)	VARCHAR2(4) NOT NULL	Worker Type Mexico 0010=Permanent Worker 0020=Eventual Worker 0030=Construction Eventual
10	REDUCED_WEEK_MEX	Character(4)	VARCHAR2(4) NOT NULL	Detail of Reduced Week for Mexico 0000=Complete Week 0010=1 Day per Week 0020=2 Day per Week 0030=3 Day per Week 0040=4 Day per Week 0050=5 Day per Week 0060=Workday less than 8 Hours
11	LOCATED_CD_MEX	Character(18)	VARCHAR2(18) NOT NULL	Location Code for Mexico.
12	SALARY_TYPE_MEX	Character(4)	VARCHAR2(4) NOT NULL	Salary Type Mexico 0010=Fixed Salary 0020=Mixed Salary 0030=Variable Salary 0040=All Salaries
13	IMS_TERM_DT_MEX	Date(10)	DATE	Mexico IMSS Termination Date
14	BALANCE_GRP_NUM	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to determine the grouping of balances from the different jobs of the employee.
15	FP_ACTION_2	Character(3)	VARCHAR2(3) NOT NULL	HFPS
16	CTG_RATE	Number(3,0)	SMALLINT NOT NULL	Category Rate
17	FP_LEGALSTAT_CD	Character(3)	VARCHAR2(3) NOT NULL	Civil Service Position Code. Prompt Table: FPMLEGALSTA_TBL
18	FP_SCNDMT_CD	Character(1)	VARCHAR2(1) NOT NULL	Secondment for FPS Y/N Table Edit
19	FP_SCND_TYP	Character(1)	VARCHAR2(1) NOT NULL	Secondment Type for FPS B=No Effect E=External Secondment I=Internal Secondment
20	FP_CIVIL_PENSION	Character(1)	VARCHAR2(1) NOT NULL	Penison for FPS Y/N Table Edit Default Value: N
21	FP_SOURCE_ORG	Character(50)	VARCHAR2(50) NOT NULL	Home Organisation for FPS
22	FP_RECEP_ORG	Character(30)	VARCHAR2(30) NOT NULL	Rec Organisation for FPS
23	FP_RETURN_CD	Character(1)	VARCHAR2(1) NOT NULL	Return Code Y/N Table Edit
24	FP_PR_LEGSTA	Character(3)	VARCHAR2(3) NOT NULL	Position for FPS Prompt Table: FPMLEGALSTA_TBL
25	FP_FOREND_DT	Date(10)	DATE	Position Expected End Date for FPS
26	FP_END_DT	Date(10)	DATE	Position Actual End Date
27	FP_CAREFRZPCT	Number(3,0)	SMALLINT NOT NULL	Career Advancment for FPS
28	FP_HIR_DOS_SIT	Character(2)	VARCHAR2(2) NOT NULL	Hire Status for FPS 00=Contract Signed 01=Hiring Done 02=Hiring Validated
29	FP_PT_PCT_DET	Character(3)	VARCHAR2(3) NOT NULL	Work Time for FPS 100=100 50=50 60=60 70=70 80=80 90=90
30	FP_TITLE_NUM	Character(10)	VARCHAR2(10) NOT NULL	Title Number for FPS
31	FP_DURATION_PCT	Number(3,0)	SMALLINT NOT NULL	Duration for FPS
32	FP_RATING_PRS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Rating for FPS Y/N Table Edit Default Value: N
33	FP_BUDGET_NBR	Number(1,0)	SMALLINT NOT NULL	Budget Nbr for FPS
34	FP_HDCNT_NBR	Number(1,0)	SMALLINT NOT NULL	Headcount for FPS
35	FP_POTENT_NBR	Number(1,0)	SMALLINT NOT NULL	Potential FTE for FPS
36	FP_RANK_CD	Character(6)	VARCHAR2(6) NOT NULL	Grade
37	FP_STEP_CD	Character(4)	VARCHAR2(4) NOT NULL	Step
38	FP_RK_ENT_DT	Date(10)	DATE	Date Entry for FPS
39	FP_CORPS_CD	Character(6)	VARCHAR2(6) NOT NULL	Corps Prompt Table: FPMCORPS_TBL
40	FP_CHG_COR_DT	Date(10)	DATE	Change Date for FPS
41	FP_CATG_FP	Character(2)	VARCHAR2(2) NOT NULL	Category for FPS A=A B=B C=C D=D X=No Existing Category
42	FP_CATG_LEVEL	Character(3)	VARCHAR2(3) NOT NULL	Category level for FPS
43	FP_RK_TRIALPD	Character(1)	VARCHAR2(1) NOT NULL	Probation Date for FPS Y/N Table Edit
44	FP_STEP_END_DT	Date(10)	DATE	Step Actual End Date for FPS
45	FP_FOR_PROM_DT	Date(10)	DATE	From Date for FPS
46	FP_NOMINATION_DT	Date(10)	DATE	Nomination Date for FPS
47	FP_TRAINEE	Character(1)	VARCHAR2(1) NOT NULL	Trainee for FPS Y/N Table Edit
48	FP_TRNE_POSN	Character(1)	VARCHAR2(1) NOT NULL	Probationary Period state for FPS A=Rejected B=None E=In progress V=Validated
49	FP_RK_PD_END_DT	Date(10)	DATE	Expected Date for FPS
50	FP_SANCTION	Character(1)	VARCHAR2(1) NOT NULL	Sanction for FPS N= S=Sanction Extension Y=Sanction
51	FP_DOWN_GRA	Character(1)	VARCHAR2(1) NOT NULL	Grade for FPS N= Y=Downgrading
52	FP_APPL_SAL_DT	Date(10)	DATE	Compensation Application for FPS
53	FP_CHG_IND	Character(1)	VARCHAR2(1) NOT NULL	Forced Indiex for FPS Y/N Table Edit
54	FP_CLD_INST	Character(1)	VARCHAR2(1) NOT NULL	Instance Terminated for FPS Y/N Table Edit
55	FP_SETID_RANK	Character(5)	VARCHAR2(5) NOT NULL	Set ID
56	FP_INSTALL_DT	Date(10)	DATE	Installation Date
57	FP_EQUIV_STEP	Character(4)	VARCHAR2(4) NOT NULL	Corresponding Step for FPS
58	FP_STEP_CD2	Character(4)	VARCHAR2(4) NOT NULL	Step for FPS
59	FP_BUSINESS_CD	Character(4)	VARCHAR2(4) NOT NULL	Occupation Code Prompt Table: FPMBUISNESS_TBL
60	FP_APPL_DT	Date(10)	DATE	Application Date
61	FP_CHG_SAL	Character(1)	VARCHAR2(1) NOT NULL	Forced Salary Y/N Table Edit
62	FP_POINTYP_CD	Character(2)	VARCHAR2(2) NOT NULL	Point Type Code Prompt Table: FPMPOINTYP_TBL
63	FP_GROSS_IND	Number(4,0)	SMALLINT NOT NULL	Gross Index
64	FP_INCS_IND	Number(4,0)	SMALLINT NOT NULL	Increased Index
65	FP_INCS_IND2	Number(4,0)	SMALLINT NOT NULL	Increased Index for FPS
66	FP_PT_PCT	Character(3)	VARCHAR2(3) NOT NULL	Part Time Percentage for FPS 050=50 060=60 070=70 080=80 090=90 100=100
67	FP_PT_END_DT	Date(10)	DATE	Part Time End date for FPS
68	FP_PT_FOREND_DT	Date(10)	DATE	Expected End Date for FPS
69	FP_COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Field for FPS
70	FP_INST_STAT	Character(1)	VARCHAR2(1) NOT NULL	Instance Status D=Request R=Actual
71	FP_RETROSPECT	Character(1)	VARCHAR2(1) NOT NULL	Retro Activity for FPS Y/N Table Edit
72	FP_ROW_END_DT	Date(10)	DATE	Job Instance End date for FPS
73	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update
74	OTHER_ID_JPN	Character(11)	VARCHAR2(11) NOT NULL	Other Identifier
75	INTCP_XFR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intercompany Transfer Flag 1=Home Company Information 2=Host Company Information
76	INTCP_XFR_START_DT	Date(10)	DATE	Intercompany transfer start date (Japan HR)
77	INTCP_XFR_END_DT	Date(10)	DATE	Intercompany Transfer End Date (Japan HR)
78	INTCP_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUSUNIT_HR_VW
79	INTCP_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Intercompany transfer department (Japan HR) Prompt Table: DEPT_INT_VW_JPN
80	INTCP_DEPTID2	Character(10)	VARCHAR2(10) NOT NULL	Department Appointment (Japan HR) Prompt Table: INTCPX_DPT_JPN
81	INTCP_SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Intercompany transfer department set ID (Japan HR)
82	INTCP_COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Intercompany transfer company (Japan HR) Prompt Table: COMPANY_TBL
83	INTCP_COMPANY2	Character(3)	VARCHAR2(3) NOT NULL	Company Appointment (JAPAN HR) Prompt Table: INTCPX_CPY_JPN
84	INTCP_SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Intercompany transfer supervisor level (Japan HR) Prompt Table: SUPV_INT_VW_JPN
85	INTCP_SUPV_LVL_ID2	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level appointment (Japan HR) Prompt Table: INTCPX_SPV_JPN
86	START_DATE_JPN	Date(10)	DATE	Tracks the beginning date of an additional appointment assignment.
87	EXP_END_DATE_JPN	Date(10)	DATE	Tracks the date in the future when the additional appointment assignment is expected to be completed.
88	END_DATE_JPN	Date(10)	DATE	The actual date that an additional appointment assignment was completed.
89	DUTIES_TYPE	Character(2)	VARCHAR2(2) NOT NULL	The type of duties for Temporary Assignments. Prompt Table: TEMP_DUTIES_TBL
90	ASSIGNMENT_ID	Number(8,0)	INTEGER NOT NULL	This is a system assigned number solely for Temporary Assignment jobs. It is used as a link between the Temporary Assignment job row and its respective Substantive job that is temporarily put on hold.
91	TARGET_COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Target Compensation Rate
92	CMP_DONT_ABSORB	Character(1)	VARCHAR2(1) NOT NULL	Don't Absorb Changes N=No Y=Yes Y/N Table Edit Default Value: N
93	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number Prompt Table: ESTB_CCC_ALL_VW
94	UNITA_PROD_CD	Character(6)	VARCHAR2(6) NOT NULL	Productive Unit Prompt Table: UNITA_PROD_TBL
95	ACTION_ITA	Character(3)	VARCHAR2(3) NOT NULL	Turnover - Action HIR=Hire LAY=Lay off LEA=Leave of Absence TER=Termination
96	ACTION_REASON_ITA	Character(3)	VARCHAR2(3) NOT NULL	Turnover Action Reason Prompt Table: TRV_ACTRSN_ITA
97	SPECIAL_HIRCTG_ITA	Character(1)	VARCHAR2(1) NOT NULL	Special Hiring Category 1=Mobility List 2=CIG List 3=Unemployed List 4=Unemployed - Weak Wrap 5=Protected
98	PART_TIME_TYPE_ITA	Character(1)	VARCHAR2(1) NOT NULL	Type of Part Time - ITA C=Cyclic H=Horizontal V=Vertical
99	PART_TIME_PERC_ITA	Number(8,4)	DECIMAL(7,4) NOT NULL	Percentage of Part Time
100	PARTTIME_ENDDT_ITA	Date(10)	DATE	Part Time End Date
101	WORKDAYS_NLD	Number(4,2)	DECIMAL(3,2) NOT NULL	Number of working days per week... This field keeps track on the number of days an employee is working. Default Value: 5
102	CONT_SAL_TYPE_BRA	Character(1)	VARCHAR2(1) NOT NULL	Contract Salary Type Brazil 1=Monthly 2=Fortnightly 3=Weekly 4=Daily 5=Hourly 6=Per Task 7=Commission 8=Other Default Value: 1
103	CBO_CD_BRA	Character(7)	VARCHAR2(7) NOT NULL	Occupation Code for Brazil Default Value: JOBCODE_TBL_BRA.CBO_CD_BRA
104	SEFIP_CATEGORY_BRA	Character(2)	VARCHAR2(2) NOT NULL	SEFIP CATEGORY Brazil 01=Employee 02=Temporary Worker 03=Worker w/FGTS benefit w/o link 04=Limited Period Employee 05=Director not employed w/FGTS 07=Underaged Intern 11=Director not employed w/o FGTS 12=Other Public Agents 13=Self-empl w/payment withholdng 14=Selfempl w/base-sal withholdng 15=Ind. transporter w/contr compe 16=Ind. transporter w/contr salar 17=Coop worker, Service Provider 18=Freight Coop, service provider 19=Political Agent 20=Non-permanent Governmnt Worker 21=Permanent Government Worker 22=Not Applicable Default Value: 01
105	UNION_CD_ALT_BRA	Character(3)	VARCHAR2(3) NOT NULL	Alternate Union Code Brazil Prompt Table: UNION_TBL