| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
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.
|
| 6 |
HOME_HOST_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Home/Host Classification
M=Home
S=Host
Default Value: M
|
| 7 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 8 |
REHIRE_DT |
Date(10) |
DATE |
Rehire Date
|
| 9 |
CMPNY_SENIORITY_DT |
Date(10) |
DATE |
Company Seniority Date
|
| 10 |
SERVICE_DT |
Date(10) |
DATE NOT NULL |
Service Date
|
| 11 |
PROF_EXPERIENCE_DT |
Date(10) |
DATE |
Professional Experience Date
|
| 12 |
LAST_VERIFICATN_DT |
Date(10) |
DATE |
Last Verification Date
|
| 13 |
EXPECTED_RETURN_DT |
Date(10) |
DATE |
Expected Return Date
|
| 14 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 15 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last Date Worked
|
| 16 |
LAST_INCREASE_DT |
Date(10) |
DATE |
Date Last Increase
|
| 17 |
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.
Y/N Table Edit
Default Value: N
|
| 18 |
BUSINESS_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Title
|
| 19 |
PROBATION_DT |
Date(10) |
DATE |
Probation Date
|
| 20 |
POSITION_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Phone number for the Position
|
| 21 |
DED_TAKEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
Default Value: R
|
| 22 |
DED_SUBSET_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Deduction Subset ID
Prompt Table:
DED_SUBSET_TBL
|
| 23 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 24 |
GVT_SCD_RETIRE |
Date(10) |
DATE |
Service Comp Date - Retire
|
| 25 |
GVT_SCD_TSP |
Date(10) |
DATE |
Service Comp Date - TSP
|
| 26 |
GVT_SCD_LEO |
Date(10) |
DATE |
Service Comp Date - LEO
|
| 27 |
GVT_SCD_SEVPAY |
Date(10) |
DATE |
Service Comp Date - Sev Pay
|
| 28 |
GVT_SEVPAY_PRV_WKS |
Number(2,0) |
SMALLINT NOT NULL |
Severance Pay Previous Weeks
|
| 29 |
GVT_MAND_RET_DT |
Date(10) |
DATE |
Mandatory Retirement Date
|
| 30 |
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
Default Value: W
|
| 31 |
GVT_INTRM_DAYS_WGI |
Number(3,0) |
SMALLINT NOT NULL |
Intermittent Days Worked
|
| 32 |
GVT_NONPAY_NOA |
Character(3) |
VARCHAR2(3) NOT NULL |
NonPay Nature of Action - Last
Prompt Table:
GVT_NOAC_TBL
|
| 33 |
GVT_NONPAY_HRS_WGI |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Non-Pay Hours WGI
|
| 34 |
GVT_NONPAY_HRS_SCD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Non-Pay Hours for SCD
|
| 35 |
GVT_NONPAY_HRS_TNR |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Career Tenure Hours
|
| 36 |
GVT_NONPAY_HRS_PRB |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Non-Pay Hours for Probation
|
| 37 |
GVT_TEMP_PRO_EXPIR |
Date(10) |
DATE |
Temp Promotion Expires
|
| 38 |
GVT_TEMP_PSN_EXPIR |
Date(10) |
DATE |
Temporary Posn Change Expires
|
| 39 |
GVT_DETAIL_EXPIRES |
Date(10) |
DATE |
Date Detail Expires
|
| 40 |
GVT_SABBATIC_EXPIR |
Date(10) |
DATE |
Date Sabbatical Expires
|
| 41 |
GVT_RTND_GRADE_BEG |
Date(10) |
DATE |
Retained Grade Begins
|
| 42 |
GVT_RTND_GRADE_EXP |
Date(10) |
DATE |
Retained Grade Expires
|
| 43 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
|
| 44 |
GVT_CURR_APT_AUTH1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Current Appointment Auth #1
Prompt Table:
GVT_LEGAL_AUTH
|
| 45 |
GVT_CURR_APT_AUTH2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Current Appointment Auth #2
Prompt Table:
GVT_LEGAL_AUTH
|
| 46 |
GVT_APPT_EXPIR_DT |
Date(10) |
DATE |
Appointment Expiration Date
|
| 47 |
GVT_CNV_BEGIN_DATE |
Date(10) |
DATE |
Conv Begin Date
|
| 48 |
GVT_CAREER_CNV_DUE |
Date(10) |
DATE |
Conversion to Career Due
|
| 49 |
GVT_CAREER_COND_DT |
Date(10) |
DATE |
Career-Cond Conv Date
|
| 50 |
GVT_APPT_LIMIT_HRS |
Number(4,0) |
SMALLINT NOT NULL |
Appointment Limit in Hours
|
| 51 |
GVT_APPT_LIMIT_DYS |
Number(3,0) |
SMALLINT NOT NULL |
Appointment Limit in Days
|
| 52 |
GVT_APPT_LIMIT_AMT |
Number(6,0) |
INTEGER NOT NULL |
Appointment Limit Amount
|
| 53 |
GVT_SUPV_PROB_DT |
Date(10) |
DATE |
Supv/Manager Probation Date
|
| 54 |
GVT_SES_PROB_DT |
Date(10) |
DATE |
SES Probation Date
|
| 55 |
GVT_ERN_PGM_PERM |
Character(2) |
VARCHAR2(2) NOT NULL |
Permanent Pay Plan - RIF
Prompt Table:
ERN_PROGRAM_TBL
|
| 56 |
GVT_OCC_SERS_PERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Permanent Occ Series - RIF
Prompt Table:
GVT_OCCUPATION
|
| 57 |
GVT_GRADE_PERM |
Character(3) |
VARCHAR2(3) NOT NULL |
Permanent Grade - RIF
|
| 58 |
GVT_COMP_AREA_PERM |
Character(2) |
VARCHAR2(2) NOT NULL |
Comp/Area Level
|
| 59 |
GVT_COMP_LVL_PERM |
Character(3) |
VARCHAR2(3) NOT NULL |
Permanent Comp Level - RIF
|
| 60 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
Y/N Table Edit
Default Value: N
|
| 61 |
GVT_SPEP |
Character(2) |
VARCHAR2(2) NOT NULL |
Special Employment Program
00=Not Applicable
59=Veteran's Readjustment Program
69=Presidential Mgt Intern
80=SES Candidate Development
99=Other
Default Value: 00
|
| 62 |
GVT_WGI_DUE_DATE |
Date(10) |
DATE |
Within-Grade Increase Due Date
|
| 63 |
GVT_DT_LEI |
Date(10) |
DATE |
Date Last Equivalent Increase
|
| 64 |
GVT_FIN_DISCLOSURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Disclosure Required
Y/N Table Edit
|
| 65 |
GVT_FIN_DISCL_DATE |
Date(10) |
DATE |
Financial Disclosure Due Date
|
| 66 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 67 |
GVT_DETL_BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
GVT Detail Bargaining Unit
Prompt Table:
GVT_BARG_UNIT
|
| 68 |
GVT_DETL_UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
GVT Detail Union Code
Prompt Table:
UNION_TBL
|
| 69 |
NEXT_REVIEW_DT |
Date(10) |
DATE |
Next Review Date
|
| 70 |
GVT_WELFARE_WK_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Welfare to Work
00=Not Applicable
50=Welfare to Work Program Hire
50=Welfare to Work Program Hire
60=Hire not Welfare to Work Prog
60=Hire not Welfare to Work Prog
Default Value: 00
|
| 71 |
GVT_NFC_PRBTN_STRT |
Date(10) |
DATE |
Federal NFC Field
|
| 72 |
GVT_NFC_SPMGREQ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Federal NFC Field
0=Not Required
1=Required
2=Served
3=Waived
Default Value: 0
|
| 73 |
GVT_NFC_SUPMGST_DT |
Date(10) |
DATE |
Federal NFC Field
|
| 74 |
TENURE_ACCR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Tenure Services
N=Do Not Accrue
Y=Accrue Tenure
|
| 75 |
FTE_TENURE |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
FTE for Tenure Accrual
|
| 76 |
EG_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Calculation Group
|
| 77 |
FTE_FLX_SRVC |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
FTE for Flex Service Accrual
|
| 78 |
CONTRACT_LENGTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Length
0=Not Applicable
1=<9 Month
1=<9 Month
2=9-10 Month
2=9-10 Month
3=11-12 Month
3=11-12 Month
4=9 Month
5=10 Month
6=11 Month
7=12 Month
8=>12 Month
|
| 79 |
APPOINT_END_DT |
Date(10) |
DATE |
Appointment End Date
|
| 80 |
NEE_PROVIDER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The ID for the Non Employee Provider, Agency, or Employer.
Prompt Table:
NEE_PROVIDR_TBL
|