| # |
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 |
CASUAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Casual Indicator
|
| 15 |
SALARY_PACKAGED |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Salary Packaged Flag
|
| 16 |
PAYROLL_STATE_AUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Sal Package - Payroll Tax State
|
| 17 |
CLASSN_CURRENT_AUS |
Number(3,0) |
SMALLINT NOT NULL |
This field identifies the classification term and level for an employee in respect of their current duties.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
|
| 18 |
WORK_SECTOR_AUS |
Character(1) |
VARCHAR2(1) NOT NULL |
The work sector in which a function is being performed in one organisational unit by a member of staff in respect of their current duties.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
1=Higher Education
2=TAFE
3=VET (AMC Only)
|
| 19 |
FUNCTION_AUS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field refers to the role performed by the employee.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
1=Teaching only function
2=Research only function
3=Teaching & Research function
4=Other function
|
| 20 |
ANN_CNTACT_HRS_AUS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
This field represents the total number of hours spent annually in a teaching job. The field is used for calculating FTE equivalence.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
|
| 21 |
TEACH_WEEKS_AUS |
Number(2,0) |
SMALLINT NOT NULL |
This field represents the total number of weeks worked by a member of staff in the role of teaching. The field is used for calculating FTE equivalence.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
|
| 22 |
CASUAL_TYPE_AUS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field translates the type of work performed by a member of the staff and is used for calculating FTE equivalence for casual types.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
L=Lecturing
R=Market/Research/Other
S=Supervise/Tutorial Workshop
|
| 23 |
TERM_TYPE_AUS |
Character(2) |
VARCHAR2(2) NOT NULL |
This field refers to the type of appointment for an employee. Employees are hired either on a limited, probation, confirmed or other terms.
This is an Australian specific code which is needed for DETYA electronic reporting purposes.
00=Limited
81=Probationary
82=Confirmed
91=Other Term
|
| 24 |
TERM_LTD_AUS |
Number(2,0) |
SMALLINT NOT NULL |
This field refers to the possible duration of appointment for an employee. Employees are hired on a limited duration basis are expected to record the duration for which they have been hired.
This is an Australian specific code which is needed for DETYA electronic reporting purposes.
|
| 25 |
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.
|
| 26 |
FP_ACTION_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
HFPS
|
| 27 |
CTG_RATE |
Number(3,0) |
SMALLINT NOT NULL |
Category Rate
|
| 28 |
FP_LEGALSTAT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Civil Service Position Code.
Prompt Table:
FPMLEGALSTA_TBL
|
| 29 |
FP_SCNDMT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondment for FPS
Y/N Table Edit
|
| 30 |
FP_SCND_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondment Type for FPS
B=No Effect
E=External Secondment
I=Internal Secondment
|
| 31 |
FP_CIVIL_PENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Penison for FPS
Y/N Table Edit
Default Value: N
|
| 32 |
FP_SOURCE_ORG |
Character(50) |
VARCHAR2(50) NOT NULL |
Home Organisation for FPS
|
| 33 |
FP_RECEP_ORG |
Character(30) |
VARCHAR2(30) NOT NULL |
Rec Organisation for FPS
|
| 34 |
FP_RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
Y/N Table Edit
|
| 35 |
FP_PR_LEGSTA |
Character(3) |
VARCHAR2(3) NOT NULL |
Position for FPS
Prompt Table:
FPMLEGALSTA_TBL
|
| 36 |
FP_FOREND_DT |
Date(10) |
DATE |
Position Expected End Date for FPS
|
| 37 |
FP_END_DT |
Date(10) |
DATE |
Position Actual End Date
|
| 38 |
FP_CAREFRZPCT |
Number(3,0) |
SMALLINT NOT NULL |
Career Advancment for FPS
|
| 39 |
FP_HIR_DOS_SIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Hire Status for FPS
00=Contract Signed
01=Hiring Done
02=Hiring Validated
|
| 40 |
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
|
| 41 |
FP_TITLE_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Title Number for FPS
|
| 42 |
FP_DURATION_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Duration for FPS
|
| 43 |
FP_RATING_PRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating for FPS
Y/N Table Edit
Default Value: N
|
| 44 |
FP_BUDGET_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Budget Nbr for FPS
|
| 45 |
FP_HDCNT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Headcount for FPS
|
| 46 |
FP_POTENT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Potential FTE for FPS
|
| 47 |
FP_RANK_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Grade
|
| 48 |
FP_STEP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Step
|
| 49 |
FP_RK_ENT_DT |
Date(10) |
DATE |
Date Entry for FPS
|
| 50 |
FP_CORPS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Corps
Prompt Table:
FPMCORPS_TBL
|
| 51 |
FP_CHG_COR_DT |
Date(10) |
DATE |
Change Date for FPS
|
| 52 |
FP_CATG_FP |
Character(2) |
VARCHAR2(2) NOT NULL |
Category for FPS
A=A
B=B
C=C
D=D
X=No Existing Category
|
| 53 |
FP_CATG_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Category level for FPS
|
| 54 |
FP_RK_TRIALPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Probation Date for FPS
Y/N Table Edit
|
| 55 |
FP_STEP_END_DT |
Date(10) |
DATE |
Step Actual End Date for FPS
|
| 56 |
FP_FOR_PROM_DT |
Date(10) |
DATE |
From Date for FPS
|
| 57 |
FP_NOMINATION_DT |
Date(10) |
DATE |
Nomination Date for FPS
|
| 58 |
FP_TRAINEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trainee for FPS
Y/N Table Edit
|
| 59 |
FP_TRNE_POSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Probationary Period state for FPS
A=Rejected
B=None
E=In progress
V=Validated
|
| 60 |
FP_RK_PD_END_DT |
Date(10) |
DATE |
Expected Date for FPS
|
| 61 |
FP_SANCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sanction for FPS
N=
S=Sanction Extension
Y=Sanction
|
| 62 |
FP_DOWN_GRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Grade for FPS
N=
Y=Downgrading
|
| 63 |
FP_APPL_SAL_DT |
Date(10) |
DATE |
Compensation Application for FPS
|
| 64 |
FP_CHG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Indiex for FPS
Y/N Table Edit
|
| 65 |
FP_CLD_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Terminated for FPS
Y/N Table Edit
|
| 66 |
FP_SETID_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Set ID
|
| 67 |
FP_INSTALL_DT |
Date(10) |
DATE |
Installation Date
|
| 68 |
FP_EQUIV_STEP |
Character(4) |
VARCHAR2(4) NOT NULL |
Corresponding Step for FPS
|
| 69 |
FP_STEP_CD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Step for FPS
|
| 70 |
FP_BUSINESS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupation Code
Prompt Table:
FPMBUISNESS_TBL
|
| 71 |
FP_APPL_DT |
Date(10) |
DATE |
Application Date
|
| 72 |
FP_CHG_SAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Salary
Y/N Table Edit
|
| 73 |
FP_POINTYP_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Point Type Code
Prompt Table:
FPMPOINTYP_TBL
|
| 74 |
FP_GROSS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Gross Index
|
| 75 |
FP_INCS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Increased Index
|
| 76 |
FP_INCS_IND2 |
Number(4,0) |
SMALLINT NOT NULL |
Increased Index for FPS
|
| 77 |
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
|
| 78 |
FP_PT_END_DT |
Date(10) |
DATE |
Part Time End date for FPS
|
| 79 |
FP_PT_FOREND_DT |
Date(10) |
DATE |
Expected End Date for FPS
|
| 80 |
FP_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Field for FPS
|
| 81 |
FP_INST_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Status
D=Request
R=Actual
|
| 82 |
FP_RETROSPECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Activity for FPS
Y/N Table Edit
|
| 83 |
FP_ROW_END_DT |
Date(10) |
DATE |
Job Instance End date for FPS
|
| 84 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|
| 85 |
OTHER_ID_JPN |
Character(11) |
VARCHAR2(11) NOT NULL |
Other Identifier
|
| 86 |
INTCP_XFR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intercompany Transfer Flag
1=Home Company Information
2=Host Company Information
|
| 87 |
INTCP_XFR_START_DT |
Date(10) |
DATE |
Intercompany transfer start date (Japan HR)
|
| 88 |
INTCP_XFR_END_DT |
Date(10) |
DATE |
Intercompany Transfer End Date (Japan HR)
|
| 89 |
INTCP_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUSUNIT_HR_VW
|
| 90 |
INTCP_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Intercompany transfer department (Japan HR)
Prompt Table:
DEPT_INT_VW_JPN
|
| 91 |
INTCP_DEPTID2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Department Appointment (Japan HR)
Prompt Table:
INTCPX_DPT_JPN
|
| 92 |
INTCP_SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Intercompany transfer department set ID (Japan HR)
|
| 93 |
INTCP_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Intercompany transfer company (Japan HR)
Prompt Table:
COMPANY_TBL
|
| 94 |
INTCP_COMPANY2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Company Appointment (JAPAN HR)
Prompt Table:
INTCPX_CPY_JPN
|
| 95 |
INTCP_SUPV_LVL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Intercompany transfer supervisor level (Japan HR)
Prompt Table:
SUPV_INT_VW_JPN
|
| 96 |
INTCP_SUPV_LVL_ID2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Supervisor Level appointment (Japan HR)
Prompt Table:
INTCPX_SPV_JPN
|
| 97 |
START_DATE_JPN |
Date(10) |
DATE |
Tracks the beginning date of an additional appointment assignment.
|
| 98 |
EXP_END_DATE_JPN |
Date(10) |
DATE |
Tracks the date in the future when the additional appointment assignment is expected to be completed.
|
| 99 |
END_DATE_JPN |
Date(10) |
DATE |
The actual date that an additional appointment assignment was completed.
|
| 100 |
SUPV_LVL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Supervisor Level ID for use in capability grade system
|
| 101 |
EXPECTED_END_DATE |
Date(10) |
DATE |
Expected End Date of a job.
|
| 102 |
AUTO_END_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is on the Job page and it allows the users to indicate whether they want the system to automatically end this job on the Expected End Date of the job.
This field is dependent on the Expected End Date having a value.
|
| 103 |
DUTIES_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
The type of duties for Temporary Assignments.
Prompt Table:
TEMP_DUTIES_TBL
|
| 104 |
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.
|
| 105 |
TARGET_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Target Compensation Rate
|
| 106 |
CMP_DONT_ABSORB |
Character(1) |
VARCHAR2(1) NOT NULL |
Don't Absorb Changes
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 107 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table:
ESTB_CCC_ALL_VW
|
| 108 |
SUSBTIT_REASON_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Substitution Reasons
01=Extended LOA
02=Maternity or Pregnacy Risk
03=Retirement at 64
04=Disabled Employee
05=Disable Employee on IT
06=Gender Violence Victims
07=Incentivated EE
09=Sexual Violence
10=Birthcare/Risk Preg/Breastfeed
|
| 109 |
SUSBTIT_EMPLID_ESP |
Character(11) |
VARCHAR2(11) NOT NULL |
Substitution Emplid
|
| 110 |
PART_SUBROGTN_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Subrogation
|
| 111 |
LABOR_RLTNSHIP_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Special Labor Relationship
|
| 112 |
INACTIVITY_TYP_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Inactivity Type
|
| 113 |
PART_STRK_ACT_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Partial Strike Activity Coeff.
|
| 114 |
UNITA_PROD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Productive Unit
Prompt Table:
UNITA_PROD_TBL
|
| 115 |
ACTION_ITA |
Character(3) |
VARCHAR2(3) NOT NULL |
Turnover - Action
HIR=Hire
LAY=Lay off
LEA=Leave of Absence
TER=Termination
|
| 116 |
ACTION_REASON_ITA |
Character(3) |
VARCHAR2(3) NOT NULL |
Turnover Action Reason
Prompt Table:
TRV_ACTRSN_ITA
|
| 117 |
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
|
| 118 |
PART_TIME_TYPE_ITA |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Part Time - ITA
C=Cyclic
H=Horizontal
V=Vertical
|
| 119 |
PART_TIME_PERC_ITA |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Percentage of Part Time
|
| 120 |
PARTTIME_ENDDT_ITA |
Date(10) |
DATE |
Part Time End Date
|
| 121 |
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
|
| 122 |
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
|
| 123 |
CBO_CD_BRA |
Character(7) |
VARCHAR2(7) NOT NULL |
Occupation Code for Brazil
Default Value: JOBCODE_TBL_BRA.CBO_CD_BRA
Prompt Table:
CBO_CD_TBL_BRA
|
| 124 |
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
|
| 125 |
UNION_CD_ALT_BRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Alternate Union Code Brazil
Prompt Table:
UNION_TBL
|