| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_TEST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Flag
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 4 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 5 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 6 |
MAR_STATUS_DT |
Date(10) |
DATE |
This is the date that the employee's Marital status is/was effective.
/* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons.
1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user.
2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
|
| 7 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 8 |
HIGHEST_EDUC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Education Level
|
| 9 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
|
| 10 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 11 |
ALTER_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Alternate Employee ID
|
| 12 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 13 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
|
| 14 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 15 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 16 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 17 |
CHECK_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Check first byte &&return type
|
| 18 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 19 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 20 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 21 |
NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Type of Name
|
| 22 |
ACTION_DT_SS |
Date(10) |
DATE |
Termination Date
|
| 23 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 24 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
|
| 25 |
ACTIVITYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
|
| 26 |
EVENTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
|
| 27 |
WORKLISTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Worklist Name
|
| 28 |
INSTANCEID |
Number(10,0) |
DECIMAL(10) NOT NULL |
For a given worklist the unique number of rows in PSWORKLIST
|
| 29 |
TRANSACTIONID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Identifier
|
| 30 |
HOME_HOST_EMPL_RCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Home/Host Employment Record #
|
| 31 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 32 |
ORG_INSTANCE_ERN |
Number(3,0) |
SMALLINT NOT NULL |
Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce.
Hire, Termination, and Service dates are captured at the Organiational Instance level.
|
| 33 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 34 |
ORIG_HIRE_DT |
Date(10) |
DATE |
Original Start Date
|
| 35 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last Date Worked
|
| 36 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 37 |
AFORE_MEX |
Character(4) |
VARCHAR2(4) NOT NULL |
AFORE retirement Found code Mexico
0010=Allianz Dresdner
0020=Banamex Aegon
0030=Bancomer
0040=Garante
0050=Inbursa
0060=ING
0070=Principal
0080=Profuturo GNP
0090=Santander Mexicano
0100=Tepeyac
0110=XXI
0120=Zurich
0130=Banorte Generalli
|
| 38 |
MED_REC_CD_MEX |
Character(3) |
VARCHAR2(3) NOT NULL |
Medic Region Code Mexico
|
| 39 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 40 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 41 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 42 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
|
| 43 |
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
|
| 44 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 45 |
MU_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Mass Update ID
|
| 46 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 47 |
MU_ACTION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Update Action flag.
|
| 48 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
|
| 49 |
COMP_RATE_POINTS |
Number(5,0) |
INTEGER NOT NULL |
Comp Rate Points
|
| 50 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 51 |
COMP_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Comp Percent
|
| 52 |
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
|
| 53 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 54 |
RATE_CODE_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Rate Code Group Name
|
| 55 |
CHANGE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Change Amount
|
| 56 |
CHANGE_PCT |
Signed Number(8,3) |
DECIMAL(6,3) NOT NULL |
Change Percent
|
| 57 |
CHANGE_PTS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Change Points
|
| 58 |
MU_COPY_FWD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Forward
|
| 59 |
UPG_MU_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Mass Update ID
|
| 60 |
MU_TRANS_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
Transaction Reference
|
| 61 |
MU_TRANS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction ID
|
| 62 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 63 |
BENEFIT_RCD_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
|
| 64 |
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
|
| 65 |
DIST_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Percent of Distribution
|
| 66 |
INSERT_PRE_FILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Insert Pre-filled Tax Location
|
| 67 |
LINE_NUM |
Number(2,0) |
SMALLINT NOT NULL |
Line #
|
| 68 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
|
| 69 |
PAGE_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Page #
|
| 70 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 71 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 72 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 73 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 74 |
UNIQUE_DIST |
Number(3,0) |
SMALLINT NOT NULL |
Record Number for Auto Insert
|
| 75 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 76 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 77 |
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.
|
| 78 |
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.
|
| 79 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 80 |
BUS_ACTIVITY_LINE1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Business Activity
|
| 81 |
BUS_ACTIVITY_LINE2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Business Activity
|
| 82 |
BUS_ACTIVITY_LINE3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Business Activity
|
| 83 |
BUS_ACTIVITY_LINE4 |
Character(40) |
VARCHAR2(40) NOT NULL |
Business Activity
|
| 84 |
CTL_ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Controlling Establishment ID
|
| 85 |
DUN_BRADSTREET_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Dun and Bradstreet Number
|
| 86 |
EEO_CO_AFFILIATED |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-1 Company Affiliated
|
| 87 |
EEO_GOV_CONTRACTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-1 Gov't Contractor Type
B=Both Prime & Sub Contractor
N=Not Applicable
P=EEO Prime Contractor
S=EEO Subcontractor
|
| 88 |
EEO_MIN_100 |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-1 Minimum 100 Employees
|
| 89 |
EEO_RPT_PREV_YR |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-1 Filed Previous Year
|
| 90 |
EEO_UNIT_NBR |
Character(7) |
VARCHAR2(7) NOT NULL |
EEO Unit Number
|
| 91 |
EMPLOY_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Employ Apprentices
|
| 92 |
NAICS |
Character(6) |
VARCHAR2(6) NOT NULL |
North Amer Ind Class Sys
|
| 93 |
SAME_BUSINESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Major business activity same
3=No report last year
N=No
Y=Yes
|
| 94 |
SAME_LOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Location same as last year
3=No report last year
N=No
Y=Yes
|
| 95 |
SIC |
Character(4) |
VARCHAR2(4) NOT NULL |
Standard Industrial Classif
|
| 96 |
VETS_100_UNIT_NBR |
Character(7) |
VARCHAR2(7) NOT NULL |
Vets 100 Unit Number
|