| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 4 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 5 |
DT_OF_DEATH |
Date(10) |
DATE |
Date of Death
|
| 6 |
COUNTRY_NM_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Supported Name Format Types
Prompt Table:
NAME_FORMAT_TBL
|
| 7 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 8 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 9 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 10 |
SECOND_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Last Name
|
| 11 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table:
NAME_PREFIX_TBL
|
| 12 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
Prompt Table:
NAME_SUFFIX_TBL
|
| 13 |
NAME_INITIALS |
Character(6) |
VARCHAR2(6) NOT NULL |
Name Initials
|
| 14 |
NAME_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Name Title
Prompt Table:
TITLE_TBL
|
| 15 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
Prompt Table:
NM_ROYPREF_GBL
|
| 16 |
NAME_ROYAL_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name - Royal Suffix
Prompt Table:
NM_ROYSUFF_GBL
|
| 17 |
LAST_NAME_PREF_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name
2=Name Partner
3=Name Partner + Own Name
4=Own Name + Name Partner
Default Value: 1
|
| 18 |
PARTNER_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
|
| 19 |
PARTNER_ROY_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.
Prompt Table:
NM_ROYPREF_GBL
|
| 20 |
PREF_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred First Name
|
| 21 |
PREF_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred Last Name
|
| 22 |
PREF_MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred Middle Name
|
| 23 |
PREF_SEC_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred Second Last Name
|
| 24 |
PREF_NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Preferred Name Prefix
Prompt Table:
NAME_PREFIX_TBL
|
| 25 |
PREF_NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Preferred Name Suffix
Prompt Table:
NAME_SUFFIX_TBL
|
| 26 |
PREF_NAME_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred Name Title
Prompt Table:
TITLE_TBL
|
| 27 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 28 |
NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 29 |
NAME_FORMAL |
Character(60) |
VARCHAR2(60) NOT NULL |
Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
|
| 30 |
NAME_FORMAL_PSF |
Character(60) |
VARCHAR2(60) NOT NULL |
Preferred Name (PS FORMAT)
|
| 31 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 32 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 33 |
MIDDLE_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Middle Name uppercase search field
|
| 34 |
SECOND_LAST_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Last Name
|
| 35 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Alternate Character Name
|
| 36 |
PARTN_LAST_NM_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Uppercase version of partner last name to improve performance on searches.
|
| 37 |
PREF_FIRST_NM_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred First Name
|
| 38 |
PREF_LAST_NM_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Uppercase version of preferred last name to improve performance on searches.
|
| 39 |
PREF_MIDL_NM_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Uppercase version of preferred middle name to improve performance on searches.
|
| 40 |
PREF_LAST_SEC_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Uppercase version of preferred second last name to improve performance on searches.
|
| 41 |
NAME_DISPLAY_SRCH |
Character(50) |
VARCHAR2(50) NOT NULL |
Uppercase version of Name to improve performance on searches.
|
| 42 |
NAME_FORMAL_SRCH |
Character(60) |
VARCHAR2(60) NOT NULL |
Uppercase version of formal name to improve performance on searches.
|
| 43 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 44 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 45 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 46 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 47 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 48 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 49 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 50 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 51 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 52 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 53 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 54 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 55 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
Prompt Table:
COUNTRY_TBL
|
| 56 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 57 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 58 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 59 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
|
| 60 |
HOME_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Home Phone #
|
| 61 |
NATIONAL_ID_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
National ID Type
Prompt Table:
NID_TYPE1_VW
|
| 62 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 63 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 64 |
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
|
| 65 |
HIGHEST_EDUC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Education Level
|
| 66 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
|
| 67 |
MILITARY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran Status / Military Status
|
| 68 |
US_WORK_ELIGIBILTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible to Work in U.S.
N=No
Y=Yes
|
| 69 |
MILIT_SITUATN_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Military Status
APA=No Country Person
BEN=Asile Right
DEG=Military Service Done
ETR=Alien
REF=Reformed (don't do milit serv)
SER=Military Service to Come
SUR=Military Service Delayed
|
| 70 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
|
| 71 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
|
| 72 |
ETHNIC_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Ethnic Group
1=White
2=Black/African American
3=Hispanic/Latino
4=Asian
5=American Indian/Alaska Native
6=Not Applicable
7=Native Hawaiian/Oth Pac Island
A=American Indian/Alaskan Native
B=Asian or Pacific Islander
C=Black, not of Hispanic origin
D=Hispanic
E=White, not of Hispanic origin
F=Asian Indian
G=Chinese
H=Filipino
J=Guamanian
K=Hawaiian
L=Japanese
M=Korean
N=Samoan
P=Vietnamese
Q=All Other Asian o Pacific Is
Y=Not Hispanic in Puerto Rico
|
| 73 |
TWO_RACES_IND_USA |
Character(1) |
VARCHAR2(1) NOT NULL |
USA Two or More (Non-Hispanic) Races Indicator
Y/N Table Edit
Default Value: N
|
| 74 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
|
| 75 |
ORIG_HIRE_DT |
Date(10) |
DATE |
Original Start Date
|
| 76 |
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
|
| 77 |
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.
|
| 78 |
CMPNY_SENIORITY_DT |
Date(10) |
DATE |
Company Seniority Date
|
| 79 |
SERVICE_DT |
Date(10) |
DATE |
Service Date
|
| 80 |
HOME_HOST_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Home/Host Classification
M=Home
S=Host
|
| 81 |
LAST_INCREASE_DT |
Date(10) |
DATE |
Date Last Increase
|
| 82 |
OWN_5PERCENT_CO |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) an employee owns 5% or more of the company. This value is used in nondiscrimination testing.
|
| 83 |
BUSINESS_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Title
|
| 84 |
PROBATION_DT |
Date(10) |
DATE |
Probation Date
|
| 85 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 86 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 87 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 88 |
EXPECTED_RETURN_DT |
Date(10) |
DATE |
Expected Return Date
|
| 89 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 90 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last Date Worked
|
| 91 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
Reports To Position Number
|
| 92 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
Prompt Table:
PERSON_NAME
|
| 93 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUS_UNIT_TBL_HR
|
| 94 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
SET_DEPT_VW
|
| 95 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
SET_JOBCD_VW2
|
| 96 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 97 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Status
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
|
| 98 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 99 |
ACTION_DT |
Date(10) |
DATE |
Action Date
|
| 100 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 101 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
SET_LOC_VW
|
| 102 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 103 |
DEPT_ENTRY_DT |
Date(10) |
DATE |
Department Entry Date
|
| 104 |
POSITION_ENTRY_DT |
Date(10) |
DATE |
Position Entry Date
|
| 105 |
SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating
|
| 106 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 107 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 108 |
FLSA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required
|
| 109 |
OFFICER_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Officer Code
C=Chairman
D=Director
N=None
O=Officer
P=President
S=Secretary
T=Treasurer
V=Vice President
|
| 110 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 111 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 112 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 113 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table:
HOLIDAY_TBL
|
| 114 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 115 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
|
| 116 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 117 |
PAID_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Paid Hours
|
| 118 |
PAID_FTE |
Number(8,6) |
DECIMAL(7,6) 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.
|
| 119 |
PAID_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Paid Work Period
|
| 120 |
FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
This field represent Full Time Equivalence
|
| 121 |
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
|
| 122 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table:
SET_SALPLAN_VW
|
| 123 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
SET_SALGRADE_VW
|
| 124 |
GRADE_ENTRY_DT |
Date(10) |
DATE |
Grade Entry Date
|
| 125 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
Prompt Table:
SET_SALSTEP_VW
|
| 126 |
STEP_ENTRY_DT |
Date(10) |
DATE |
Step Entry Date
|
| 127 |
GL_PAY_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
General Ledger Pay Type
|
| 128 |
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
Prompt Table:
COMP_FREQ_VW
|
| 129 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 130 |
CHANGE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Change Amount
|
| 131 |
CHANGE_PCT |
Signed Number(8,3) |
DECIMAL(6,3) NOT NULL |
Change Percent
|
| 132 |
ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Annual Rate
|
| 133 |
MONTHLY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Monthly Rate
|
| 134 |
DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Daily Rate
|
| 135 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 136 |
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.
|
| 137 |
SHIFT_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Shift Differential Rate
|
| 138 |
SHIFT_FACTOR |
Number(5,3) |
DECIMAL(4,3) NOT NULL |
Shift Differential Factor
|
| 139 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 140 |
DIRECTLY_TIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
|
| 141 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
|
| 142 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 143 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 144 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 145 |
SETID_SALARY |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary Set ID
|
| 146 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 147 |
GP_ELIG_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Eligibility Group
|
| 148 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 149 |
GP_ASOF_DT_EXG_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used as a flag to determine whether to use a default exchange rate or not.
B=Pay Period Begin Date
E=Pay Period End Date
P=Payment Date
|
| 150 |
JOB_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job
|
| 151 |
PAY_UNION_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Union Fee
|
| 152 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
Prompt Table:
UNION_TBL
|
| 153 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
|
| 154 |
UNION_SENIORITY_DT |
Date(10) |
DATE |
Union Seniority Date
|
| 155 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
|
| 156 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
EMPL_CTG
|
| 157 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table:
EMPL_CTG_L1_VW
|
| 158 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table:
EMPL_CTG_L2_VW
|
| 159 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
Prompt Table:
EMPL_CTG_L3_VW
|
| 160 |
SETID_LBR_AGRMNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Labor Agreement SetID
|
| 161 |
WPP_STOP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Flag to indicated that Wage Progression is stopped on this Assignment.
|
| 162 |
LABOR_FACILITY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Labor Facility ID
|
| 163 |
LBR_FAC_ENTRY_DT |
Date(10) |
DATE |
Date the Person was added to this Labor Facility.
|
| 164 |
LAYOFF_EXEMPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Flag to indicate if a Person's Assignment is exempt from Layoff.
|
| 165 |
LAYOFF_EXEMPT_RSN |
Character(11) |
VARCHAR2(11) NOT NULL |
Reason for the Exemption from Layoff
|
| 166 |
VALUE_1_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 167 |
VALUE_2_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 168 |
VALUE_3_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HCR
|
| 169 |
VALUE_4_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 170 |
VALUE_5_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 171 |
GVT_SCD_RETIRE |
Date(10) |
DATE |
Service Comp Date - Retire
|
| 172 |
GVT_MAND_RET_DT |
Date(10) |
DATE |
Mandatory Retirement Date
|
| 173 |
GVT_SCD_TSP |
Date(10) |
DATE |
Service Comp Date - TSP
|
| 174 |
GVT_SCD_SEVPAY |
Date(10) |
DATE |
Service Comp Date - Sev Pay
|
| 175 |
GVT_DT_LEI |
Date(10) |
DATE |
Date Last Equivalent Increase
|
| 176 |
GVT_PAY_BASIS |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Basis
BW=Bi-weekly
FB=Fee Basis
PA=Per Annum
PD=Per Diem
PH=Per Hour
PM=Per Month
PW=Piece Work
SM=Semi-monthly
SY=School Year
WC=Without Compensation
|
| 177 |
GVT_WGI_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Current WGI Status
A=Approved
C=WGI Created
D=Denied
M=Manual WGI
N=WGI Not Applicable
P=Postponed
W=Waiting WGI Processing
|
| 178 |
GVT_WGI_DUE_DATE |
Date(10) |
DATE |
Within-Grade Increase Due Date
|
| 179 |
GVT_INTRM_DAYS_WGI |
Number(3,0) |
SMALLINT NOT NULL |
Intermittent Days Worked
|
| 180 |
GVT_LOCALITY_ADJ |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Locality Adjustment
|
| 181 |
GVT_WORK_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Schedule
B=Baylor Plan
F=Full Time
G=Full Time Seasonal
I=Intermittent
J=Intermittent-Seasonal
P=Part Time
Q=Part-Time Seasonal
R=Part-Time Phased Retiree
S=Part-Time Job Sharer
T=Part-Time Seasonal Job Sharer
|
| 182 |
GVT_SEVPAY_PRV_WKS |
Number(2,0) |
SMALLINT NOT NULL |
Severance Pay Previous Weeks
|
| 183 |
GVT_BIWEEKLY_RT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Biweekly Rate
|
| 184 |
GVT_STEP |
Character(2) |
VARCHAR2(2) NOT NULL |
US Federal Step
|
| 185 |
GVT_RTND_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained Pay Plan
Prompt Table:
ERN_PROGRAM_TBL
|
| 186 |
GVT_RTND_SAL_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Retained Pay Table
|
| 187 |
GVT_RTND_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Retained Grade
|
| 188 |
GVT_RTND_STEP |
Number(2,0) |
SMALLINT NOT NULL |
Retained Step
|
| 189 |
GVT_RTND_GVT_STEP |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained US Federal Step
|
| 190 |
GVT_RTND_GRADE_BEG |
Date(10) |
DATE |
Retained Grade Begins
|
| 191 |
GVT_RTND_GRADE_EXP |
Date(10) |
DATE |
Retained Grade Expires
|
| 192 |
GVT_TEMP_PRO_EXPIR |
Date(10) |
DATE |
Temp Promotion Expires
|
| 193 |
GVT_TEMP_PSN_EXPIR |
Date(10) |
DATE |
Temporary Posn Change Expires
|
| 194 |
GVT_DETAIL_EXPIRES |
Date(10) |
DATE |
Date Detail Expires
|
| 195 |
GVT_SABBATIC_EXPIR |
Date(10) |
DATE |
Date Sabbatical Expires
|
| 196 |
GVT_TYPE_OF_APPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of Appointment
10=Career (Competitive Svc Perm)
15=Career-Conditional (Comp Perm)
20=Nonpermanent (Comp NonPerm)
30=Schedule A (Except Svc Perm)
32=Schedule B (Except Svc Perm)
34=Schedule C (Except Svc Perm)
36=Executive (Except Svc Perm)
38=Other (Except Svc Perm)
40=Schedule A (Except NonPerm)
42=Schedule B (Except NonPerm)
44=Schedule C (Except NonPerm)
46=Executive (Except NonPerm)
48=Other (Except NonPerm)
50=Career (Senior Exec Perm)
55=Noncareer (Senior Exec Perm)
60=Limited Term (Senior Exec NPrm
65=Limited Emergency (SES NPerm)
|
| 197 |
GVT_APPT_EXPIR_DT |
Date(10) |
DATE |
Appointment Expiration Date
|
| 198 |
GVT_CAREER_CNV_DUE |
Date(10) |
DATE |
Conversion To Career Due
|
| 199 |
GVT_SUPV_PROB_DT |
Date(10) |
DATE |
Supv/Manager Probation Date
|
| 200 |
GVT_SES_PROB_DT |
Date(10) |
DATE |
SES Probation Date
|
| 201 |
GVT_SEC_CLR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Security Clearance Status
A=Approved
B=Pending - Investigative Agency
C=Pending - Employee
D=Pending - Agency
N=Not Applicable
S=Suspended
|
| 202 |
GVT_CLRNCE_STAT_DT |
Date(10) |
DATE |
Security Clearance Status Date
|
| 203 |
EEO1CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-1 Job Category
1=Officials and Managers
2=Professionals
3=Technicians
4=Sales Workers
5=Administrative Support Workers
6=Craft Workers
7=Operatives
8=Laborers and Helpers
9=Service Workers
A=Executive/Sr Level Officials
B=First/Mid Level Officials
N=No EEO-1 Reporting
|
| 204 |
EEO4CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-4 Job Category
1=Officials and Administrators
2=Professionals
3=Technicians
4=Protective Service
5=Paraprofessionals
6=Administrative Support
7=Skilled Craft
8=Service Maintenance
N=No EEO-4 Reporting
|
| 205 |
EEO5CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
EEO-5 Job Category
1=Officials,Administrators,Mgrs
10=Librarian/Audiovisual
11=Consultants/Supv.of Instructn
12=Other Professional Staff
13=Teacher Aides
14=Technicians
15=Clerical/Secretarial
16=Service Workers
17=Craft Workers (Skilled)
18=Laborers (Unskilled)
2=Principals
3=Asst. Principals-Teaching
4=Asst. Principals-Nonteaching
5=Elementary Classroom Teachers
6=Secondary Classroom Teachers
7=Other Classroom Teachers
8=Guidance
9=Psychological
N=No EEO-5 Reporting
|
| 206 |
EEO6CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
EEO-6 Job Category
1=Executive/Admin/Managerial
2=Faculty
3=Professional Nonfaculty
4=Secretarial/Clerical
5=Technical/Paraprofessional
6=Skilled Crafts
7=Service Maintenance Workers
N=No EEO-6 Reporting
|
| 207 |
EEO_JOB_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
EEO Job Group
|
| 208 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
|
| 209 |
JOB_KNOWHOW_POINTS |
Number(5,0) |
INTEGER NOT NULL |
Knowhow-Points
|
| 210 |
JOB_ACCNTAB_POINTS |
Number(5,0) |
INTEGER NOT NULL |
Accountability-Points
|
| 211 |
JOB_PROBSLV_POINTS |
Number(5,0) |
INTEGER NOT NULL |
Problem-Solving-Points
|
| 212 |
JOB_POINTS_TOTAL |
Number(5,0) |
INTEGER NOT NULL |
Total Points
|
| 213 |
JOB_KNOWHOW_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Knowhow-Percent
|
| 214 |
JOB_ACCNTAB_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Accountability-Percent
|
| 215 |
JOB_PROBSLV_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Problem-Solving-Percent
|
| 216 |
IPEDSSCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
IPEDS-S Job Category
|
| 217 |
GVT_ORG_TTL_DESCR |
Character(70) |
VARCHAR2(70) NOT NULL |
Organization Position Title
|
| 218 |
MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Manager ID
Prompt Table:
PERSON_NAME
|
| 219 |
EEO4_FUNCTION |
Character(2) |
VARCHAR2(2) NOT NULL |
U.S. EEO4 Function
01=Financial Administration
02=Streets and Highways
03=Public Welfare
04=Police Protection
05=Fire Protection
06=Natural Resources
07=Hospitals & Sanatoriums
08=Health
09=Housing
10=Community Development
11=Corrections
12=Utilities & Transportation
13=Sanitation & Sewage
14=Employment Security
15=Other
99=Not Counted for EEO Reporting
|
| 220 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 221 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 222 |
JOBTITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Job Title
|
| 223 |
JOBTITLE_ABBRV |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Name
|
| 224 |
DEPTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Department Name
|
| 225 |
DEPTNAME_ABBRV |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Name
|
| 226 |
REHIRE_DT |
Date(10) |
DATE |
Rehire Date
|
| 227 |
WORK_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Work Phone #
|
| 228 |
NID_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
National ID Country
|
| 229 |
GVT_OVERTIME_RT |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Overtime Hourly Rate
|
| 230 |
GVT_RTND_PAY_BASIS |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained Pay Basis
|
| 231 |
SEC_CLEARANCE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Security Clearance Type
|