| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 2 |
RA_ATTRIB_SEQ |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile / attribute sequence numbers
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 4 |
RA_EMPL_RCD |
Number(18,0) |
DECIMAL(18) NOT NULL |
Character field copy of EMPL_REC used by marketing profiles due to numeric limitations.
|
| 5 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 6 |
RA_EFFSEQ |
Number(18,0) |
DECIMAL(18) NOT NULL |
Character field copy of EFFSEQ used by marketing profiles due to numeric limitations.
|
| 7 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
|
| 8 |
JOBCODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Job Code or Job Title.
|
| 9 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
POSITION_NBR field used in the HCM/ CRM sync Application Messages.
|
| 10 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employment Status. e.g., Active, Leave of Absence, Terminated, Retired, etc.
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
|
| 11 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
This field describes job action in job details record.
|
| 12 |
ACTION_DT |
Date(10) |
DATE |
Action Date - this field is brought over from HRMS.
Default Value: %date
|
| 13 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Action reason for Job details.
|
| 14 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
|
| 15 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code field used in HD_360_RESPONSE_SYNC message.
|
| 16 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 17 |
DEPT_ENTRY_DT |
Date(10) |
DATE |
This is the department entry date field.
|
| 18 |
POSITION_ENTRY_DT |
Date(10) |
DATE |
POSITION_ENTRY_DT field is being used in one of the HCM/CRM Application Messages.
|
| 19 |
SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
SHIFT field used in the HCM/ CRM sync Application Messages.
1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
Default Value: N
|
| 20 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether the worker is a Regular employee or a Temporary employee.
R=Regular
T=Temporary
Default Value: R
|
| 21 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether the employee works Full Time or Part Time.
F=Full-Time
P=Part-Time
Default Value: F
|
| 22 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 23 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Group field used in HD_360_RESPONSE_SYNC message.
|
| 24 |
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.
|
| 25 |
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.
|
| 26 |
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.
|
| 27 |
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.
|
| 28 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This is the employee type field.
|
| 29 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
This is the holiday schedule field.
|
| 30 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
STD_HRS_FREQUENCY field used in the HCM/ CRM sync Application Messages.
|
| 31 |
OFFICER_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Officer Code for a company. E.g., Chairman, Director, President, Treasurer, etc.
C=Chairman
D=Director
N=None
O=Officer
P=President
S=Secretary
T=Treasurer
V=Vice President
Default Value: N
|
| 32 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification.
A=Assignee
C=Consultant
E=Expatriate
G=Agency/Temp
I=Intern
P=Apprentice
R=Contractor
T=Trainee
|
| 33 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
SAL_ADMIN_PLAN field used in the HCM/ CRM sync Application Messages.
|
| 34 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
This is the salary grade field.
|
| 35 |
GRADE_ENTRY_DT |
Date(10) |
DATE |
This is the Grade Entry Date field.
|
| 36 |
STEP_ENTRY_DT |
Date(10) |
DATE |
STEP_ENTRY_DT field used in the HCM/ CRM sync Application Messages.
|
| 37 |
SALARY_MATRIX_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
SALARY_MATRIX_CD field used in the HCM/ CRM sync Application Messages.
|
| 38 |
RATING_SCALE |
Character(4) |
VARCHAR2(4) NOT NULL |
RATING_SCALE field used in the HCM/ CRM sync Application Messages.
|
| 39 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
REVIEW_RATING field used in the HCM/ CRM sync Application Messages.
|
| 40 |
REVIEW_DT |
Date(10) |
DATE |
REVIEW_DT field used in the HCM/ CRM sync Application Messages.
|
| 41 |
COMP_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
|
| 42 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
|
| 43 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 44 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 45 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
SETID_JOBCODE field used in the HCM/ CRM sync Application Messages.
|
| 46 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 47 |
SETID_SALARY |
Character(5) |
VARCHAR2(5) NOT NULL |
SETID_SALARY field used in the HCM/ CRM sync Application Messages.
|
| 48 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
REG_REGION field used in the HCM / CRM sync Application Messages.
|
| 49 |
DIRECTLY_TIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
This is the direct indication of the tip field.
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
Default Value: JOBCODE_TBL.DIRECTLY_TIPPED
|
| 50 |
FLSA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative
E=Executive
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
X=No FLSA Required
|
| 51 |
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
|
| 52 |
FUNCTION_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Function Code
|
| 53 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 54 |
PAID_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Paid Work Period
|
| 55 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 56 |
UNION_FULL_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Union Full/Part Time
|
| 57 |
UNION_POS |
Character(1) |
VARCHAR2(1) NOT NULL |
Union Position
|
| 58 |
UNITA_PROD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Productive Unit
|
| 59 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
UNION_CD field used in the HCM/ CRM sync Application Messages.
|
| 60 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
|
| 61 |
UNION_SENIORITY_DT |
Date(10) |
DATE |
Union Seniority Date
|
| 62 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
|
| 63 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement. This field gets the value from HCM.
|
| 64 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category. Data is fetched from HCM.
|
| 65 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
|
| 66 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
|
| 67 |
FICA_STATUS_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
FICA Status-Employee
E=Exempt
M=Medicare only
N=Subject
|
| 68 |
SUPERVISOR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
ID of a worker's supervisor.
|
| 69 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
REPORTS_TO field used in the HCM/ CRM sync Application Messages.
|
| 70 |
HR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
An indication whether a worker is still on payroll.
HR_STATUS = "A" if EMPL_STATUS in ("A", "L", "P", "S", "W");
HR_STATUS = "A" if EMPL_STATUS not in ("A", "L", "P", "S", "W");
A=Active
I=Inactive
|
| 71 |
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.
Used to Map HCM Messages.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
|
| 72 |
POI_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines the Transactional usage of POIs in HRMS.
|
| 73 |
HIRE_DT |
Date(10) |
DATE |
Hire Date field used in HD_360_RESPONSE_SYNC message.
|
| 74 |
TERMINATION_DT |
Date(10) |
DATE |
TERMINATION_DT field used in the HCM/ CRM sync Application Messages.
|
| 75 |
ASGN_START_DT |
Date(10) |
DATE |
Start date of an assignment. This is different from the Person's Hire date.
|
| 76 |
ASGN_END_DT |
Date(10) |
DATE |
End date of the specific EMPL_RCD assignment. This is different from the Person's Termination date.
|
| 77 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last date at Work
|
| 78 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
This is the compensation rate field.
|
| 79 |
CHANGE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This is the change amount field.
|
| 80 |
ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
ANNUAL RATE
|
| 81 |
MONTHLY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
MONTHLY RATE
|
| 82 |
DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
DAILY RATE
|
| 83 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
HOURLY RATE
|
| 84 |
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.
|
| 85 |
SHIFT_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
SHIFT RATE
|
| 86 |
RA_STD_HOURS |
Number(22,3) |
DECIMAL(21,3) NOT NULL |
Standard Hours field used in HD_360_RESPONSE_SYNC message.
RA_STD_HOURS is a character copy of numeric STD_HOURS for profiles use
|
| 87 |
RA_STEP |
Number(18,0) |
DECIMAL(18) NOT NULL |
STEP field is being use in one of the HCM/CRM Application Message.
RA_STEP is a character copy of numeric STEP for profiles use
|
| 88 |
RA_CHANGE_PCT |
Number(22,3) |
DECIMAL(21,3) NOT NULL |
This is the change percent field.
RA_CHANGE_PCT is a character copy of numeric CHANGE_PCT for profiles use
|
| 89 |
RA_SHIFT_FACTOR |
Number(22,3) |
DECIMAL(21,3) NOT NULL |
SHIFT_FACTOR field used in the HCM/ CRM sync Application Messages.
RA_SHIFT_FACTOR is a character copy of numeric SHIFT_FACTOR for profiles use
|
| 90 |
RA_CTG_RATE |
Number(18,0) |
DECIMAL(18) NOT NULL |
RA_CTG_RATE is a character copy of numeric CTG_RATE for profiles use
|
| 91 |
RA_PAID_HOURS |
Number(21,2) |
DECIMAL(20,2) NOT NULL |
Worker Paid hours. Displayed as part of Job Summary on HRMS 360-degree view.
RA_PAID_HOURS is a character copy of numeric PAID_HOURS for profiles use
|
| 92 |
RA_PAID_FTE |
Number(21,2) |
DECIMAL(20,2) 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.
RA_PAID_FTE is a character copy of numeric PAID_FTE for profiles use
|
| 93 |
RA_FTE |
Number(21,2) |
DECIMAL(20,2) NOT NULL |
This is the full time employee field.
RA_FTE is a character copy of numeric FTE for profiles use
|
| 94 |
RA_WORK_DAY_HOURS |
Number(22,3) |
DECIMAL(21,3) NOT NULL |
RA_WORK_DAY_HOURS is a character copy of numeric WORK_DAY_HOURS for profiles use
|