| # |
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
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
|
| 8 |
TAX_BASIS_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Basis
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 |
Action after Retroactive Event
|
| 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 |
Employee on Secondment
Y/N Table Edit
|
| 30 |
FP_SCND_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondment Type (Int,Ext)
B=No Effect
E=External Secondment
I=Internal Secondment
|
| 31 |
FP_CIVIL_PENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Leads to Civil Pension
Y/N Table Edit
Default Value: N
|
| 32 |
FP_SOURCE_ORG |
Character(50) |
VARCHAR2(50) NOT NULL |
Home Organization
|
| 33 |
FP_RECEP_ORG |
Character(30) |
VARCHAR2(30) NOT NULL |
Receiving Organization
|
| 34 |
FP_RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return
Y/N Table Edit
|
| 35 |
FP_PR_LEGSTA |
Character(3) |
VARCHAR2(3) NOT NULL |
Position before Return
Prompt Table:
FPMLEGALSTA_TBL
|
| 36 |
FP_FOREND_DT |
Date(10) |
DATE |
Position Expected End Date
|
| 37 |
FP_END_DT |
Date(10) |
DATE |
Position Actual End Date
|
| 38 |
FP_CAREFRZPCT |
Number(3,0) |
SMALLINT NOT NULL |
Career Advancement %
|
| 39 |
FP_HIR_DOS_SIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Hire Status
00=Contract Signed
01=Hiring Done
02=Hiring Validated
|
| 40 |
FP_PT_PCT_DET |
Character(3) |
VARCHAR2(3) NOT NULL |
Working Time % on Secondment
100=100
50=50
60=60
70=70
80=80
90=90
|
| 41 |
FP_TITLE_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Title Number
|
| 42 |
FP_DURATION_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Advancement % Service Length
|
| 43 |
FP_RATING_PRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating AttendanceFlag
Y/N Table Edit
Default Value: N
|
| 44 |
FP_BUDGET_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Budget Headcount
|
| 45 |
FP_HDCNT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Statutory Headcount
|
| 46 |
FP_POTENT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Potential Full-Time Equivalent
|
| 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 |
Grade Entry Date
|
| 50 |
FP_CORPS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Corps
Prompt Table:
FPMCORPS_TBL
|
| 51 |
FP_CHG_COR_DT |
Date(10) |
DATE |
Corps Change Date
|
| 52 |
FP_CATG_FP |
Character(2) |
VARCHAR2(2) NOT NULL |
Civil Service Category
A=A
B=B
C=C
D=D
X=No Existing Category
|
| 53 |
FP_CATG_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Category Level
|
| 54 |
FP_RK_TRIALPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Probation Period Grade
Y/N Table Edit
|
| 55 |
FP_STEP_END_DT |
Date(10) |
DATE |
(Sub)Step Actual End Date
|
| 56 |
FP_FOR_PROM_DT |
Date(10) |
DATE |
Expected Advancement Date
|
| 57 |
FP_NOMINATION_DT |
Date(10) |
DATE |
Appointment Date
|
| 58 |
FP_TRAINEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trainee
Y/N Table Edit
|
| 59 |
FP_TRNE_POSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Probationary Period State
A=Rejected
B=None
E=In progress
V=Validated
|
| 60 |
FP_RK_PD_END_DT |
Date(10) |
DATE |
PPd Expected End Date
|
| 61 |
FP_SANCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sanction
N=
S=Sanction Extension
Y=Sanction
|
| 62 |
FP_DOWN_GRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Demotion
N=
Y=Downgrading
|
| 63 |
FP_APPL_SAL_DT |
Date(10) |
DATE |
Compensation Application Date
|
| 64 |
FP_CHG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Index
Y/N Table Edit
|
| 65 |
FP_CLD_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Terminated
Y/N Table Edit
|
| 66 |
FP_SETID_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 67 |
FP_INSTALL_DT |
Date(10) |
DATE |
Installation Date
|
| 68 |
FP_EQUIV_STEP |
Character(4) |
VARCHAR2(4) NOT NULL |
Corresponding Step
|
| 69 |
FP_STEP_CD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Derived Step
|
| 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 2
|
| 77 |
FP_PT_PCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Working Time Percentage
050=50
060=60
070=70
080=80
090=90
100=100
|
| 78 |
FP_PT_END_DT |
Date(10) |
DATE |
Part-Time End Date
|
| 79 |
FP_PT_FOREND_DT |
Date(10) |
DATE |
PT Expected End Date
|
| 80 |
FP_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 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 |
Retroactivity Code
Y/N Table Edit
|
| 83 |
FP_ROW_END_DT |
Date(10) |
DATE |
JOB Instance End Date
|
| 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 Dt
|
| 88 |
INTCP_XFR_END_DT |
Date(10) |
DATE |
Intercompany Transfer End Date
|
| 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 |
Department
Prompt Table:
DEPT_INT_VW_JPN
|
| 91 |
INTCP_DEPTID2 |
Character(10) |
VARCHAR2(10) NOT NULL |
External DeptID
Prompt Table:
INTCPX_DPT_JPN
|
| 92 |
INTCP_SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Intcmpny Trasnfer Dept SetID
|
| 93 |
INTCP_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Intercompany Transfer Company
Prompt Table:
COMPANY_TBL
|
| 94 |
INTCP_COMPANY2 |
Character(3) |
VARCHAR2(3) NOT NULL |
External Company
Prompt Table:
INTCPX_CPY_JPN
|
| 95 |
INTCP_SUPV_LVL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Intcmpny Transfer Supv Lvl
Prompt Table:
SUPV_INT_VW_JPN
|
| 96 |
INTCP_SUPV_LVL_ID2 |
Character(8) |
VARCHAR2(8) NOT NULL |
External Supv Lvl
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
|
| 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(1) |
VARCHAR2(1) NOT NULL |
Inactivity Type
0=End Inactivity Period
1=Inactivity Period
2=Total Strike
3=Partial Strike
4=Trienniums Public Workers
5=Work Absence
6=Hiring w/o Salary
7=Unpaid Leave
8=Provisional Suspension
9=No Resolved Provisinl Suspn
A=Resolved Provisinl Suspensn
B=ERE Tot wo Benefit
C=ERE Part wo Benefit
D=ERE Part wo Bnf&Strk
H=Reservist Activation Period
I=ERE Tot Force Majeure
J=ERE Part Force Majeure
K=ERE Part Force Majeure&Strk
L=Maternity leave child/fam care
|
| 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
|
| 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
|