| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSONAL_DATA.EMPLID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
field used in HD_360_RESPONSE_SYNC message.
|
| 3 |
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.
|
| 4 |
HOME_HOST_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
This is the Home/Host class field.
M=Home
S=Host
Default Value: M
|
| 5 |
HIRE_DT |
Date(10) |
DATE |
Hire Date field used in HD_360_RESPONSE_SYNC message.
|
| 6 |
REHIRE_DT |
Date(10) |
DATE |
REHIRE_DT field used in the HCM/ CRM sync Application Messages.
|
| 7 |
CMPNY_SENIORITY_DT |
Date(10) |
DATE |
This is the company seniority date.
|
| 8 |
SERVICE_DT |
Date(10) |
DATE |
Service Date Field. This Field is imported into CRM DB from Human Resources Database.
|
| 9 |
PROF_EXPERIENCE_DT |
Date(10) |
DATE |
PROF_EXPERIENCE_DT field used in the HCM/ CRM sync Application Messages.
|
| 10 |
LAST_VERIFICATN_DT |
Date(10) |
DATE |
Last Verification Date
|
| 11 |
EXPECTED_RETURN_DT |
Date(10) |
DATE |
This is the date we expect to get some return...
|
| 12 |
TERMINATION_DT |
Date(10) |
DATE |
TERMINATION_DT field used in the HCM/ CRM sync Application Messages.
|
| 13 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last date at Work
|
| 14 |
LAST_INCREASE_DT |
Date(10) |
DATE |
Date of Last Increase
|
| 15 |
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
|
| 16 |
BUSINESS_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
The business title of a worker.
|
| 17 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
REPORTS_TO field used in the HCM/ CRM sync Application Messages.
|
| 18 |
SUPERVISOR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
ID of a worker's supervisor.
|
| 19 |
PROBATION_DT |
Date(10) |
DATE |
PROBATION_DT field used in the HCM/ CRM sync Application Messages.
|
| 20 |
SECURITY_CLEARANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
SECURITY_CLEARANCE field used in the HCM/ CRM sync Application Messages.
0=Not Required
1=Classified
2=Secret
3=Top Secret
4=Sensitive Compartmented Info
5=Q Sensitive
6=Q Non-Sensitive
7=L (Atomic Energy Act)
8=Other
|
| 21 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
phone type field to store value of phone type.
BUSN=Business Phone
CAMP=Campus
CELL=Cellular Phone
DFLT=Default
DORM=Dormitory
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 22 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Country Code values.
|
| 23 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
This field stores the Telephone number.
|
| 24 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
This field stores the Phone extension.
|
| 25 |
TIME_RPT_LOC |
Character(6) |
VARCHAR2(6) NOT NULL |
TIME_RPT_LOC field used in the HCM/ CRM sync Application Messages.
|
| 26 |
JOB_REPORTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Reporting Required
Y/N Table Edit
Default Value: N
|
| 27 |
DED_TAKEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Govern
Default Value: D
|
| 28 |
DED_SUBSET_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
This is the deduction subset identification number.
|
| 29 |
GVT_SCD_RETIRE |
Date(10) |
DATE |
Service Comp Date - Retire
|
| 30 |
GVT_SCD_TSP |
Date(10) |
DATE |
Service Comp Date - TSP
|
| 31 |
GVT_SCD_LEO |
Date(10) |
DATE |
Service Comp Date - LEO
|
| 32 |
GVT_SCD_SEVPAY |
Date(10) |
DATE |
Service Comp Date - Sev Pay
|
| 33 |
GVT_SEVPAY_PRV_WKS |
Number(2,0) |
SMALLINT NOT NULL |
Severnce Pay Previous Weeks
|
| 34 |
GVT_MAND_RET_DT |
Date(10) |
DATE |
Mandatory Retirement Date
|
| 35 |
GVT_WGI_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Current WGI Status
A=Approved
C=WGI Created
D=Denied
N=WGI Not Applicable
P=Postponed
W=Waiting WGI Processing
Default Value: W
|
| 36 |
GVT_INTRM_DAYS_WGI |
Number(3,0) |
SMALLINT NOT NULL |
Intermittent Days Worked
|
| 37 |
GVT_NONPAY_NOA |
Character(3) |
VARCHAR2(3) NOT NULL |
NonPay Nature of Action - Last
|
| 38 |
GVT_NONPAY_HRS_WGI |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Non-Pay Hours WGI
|
| 39 |
GVT_NONPAY_HRS_SCD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Non-Pay Hours for SCD
|
| 40 |
GVT_NONPAY_HRS_TNR |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Career Tenure Hours
|
| 41 |
GVT_NONPAY_HRS_PRB |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Non-Pay Hours for Probation
|
| 42 |
GVT_TEMP_PRO_EXPIR |
Date(10) |
DATE |
Temp Promotion Expires
|
| 43 |
GVT_TEMP_PSN_EXPIR |
Date(10) |
DATE |
Temporary Posn Change Expires
|
| 44 |
GVT_DETAIL_EXPIRES |
Date(10) |
DATE |
Date Detail Expires
|
| 45 |
GVT_SABBATIC_EXPIR |
Date(10) |
DATE |
Date Sabbatical Expires
|
| 46 |
GVT_RTND_GRADE_BEG |
Date(10) |
DATE |
Retained Grade Begins
|
| 47 |
GVT_RTND_GRADE_EXP |
Date(10) |
DATE |
Retained Grade Expires
|
| 48 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
|
| 49 |
GVT_CURR_APT_AUTH1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Current Appointment Auth #1
|
| 50 |
GVT_CURR_APT_AUTH2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Current Appointment Auth #2
|
| 51 |
GVT_APPT_EXPIR_DT |
Date(10) |
DATE |
Appointment Expiration Date
|
| 52 |
GVT_CNV_BEGIN_DATE |
Date(10) |
DATE |
Conv Begin Date
|
| 53 |
GVT_CAREER_CNV_DUE |
Date(10) |
DATE |
Conversion to Career Due
|
| 54 |
GVT_CAREER_COND_DT |
Date(10) |
DATE |
Career-Cond Conv Date
|
| 55 |
GVT_APPT_LIMIT_HRS |
Number(4,0) |
SMALLINT NOT NULL |
Appointment Limit in Hours
|
| 56 |
GVT_APPT_LIMIT_DYS |
Number(3,0) |
SMALLINT NOT NULL |
Appointment Limit in Days
|
| 57 |
GVT_APPT_LIMIT_AMT |
Number(6,0) |
INTEGER NOT NULL |
Appointment Limit Amount
|
| 58 |
GVT_SUPV_PROB_DT |
Date(10) |
DATE |
Supv/Manager Probation Date
|
| 59 |
GVT_SES_PROB_DT |
Date(10) |
DATE |
SES Probation Date
|
| 60 |
GVT_SEC_CLR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Security Clearance Status
Default Value: N
|
| 61 |
GVT_CLRNCE_STAT_DT |
Date(10) |
DATE |
Security Clearance Status Date
Default Value: %date
|
| 62 |
GVT_ERN_PGM_PERM |
Character(2) |
VARCHAR2(2) NOT NULL |
Permanent Pay Plan - RIF
|
| 63 |
GVT_OCC_SERS_PERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Permanent Occ Series - RIF
|
| 64 |
GVT_GRADE_PERM |
Character(3) |
VARCHAR2(3) NOT NULL |
Permanent Grade - RIF
|
| 65 |
GVT_COMP_AREA_PERM |
Character(2) |
VARCHAR2(2) NOT NULL |
Comp/Area Level
|
| 66 |
GVT_COMP_LVL_PERM |
Character(3) |
VARCHAR2(3) NOT NULL |
Permanent Comp Level - RIF
|
| 67 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
Y/N Table Edit
Default Value: N
|
| 68 |
GVT_SPEP |
Character(2) |
VARCHAR2(2) NOT NULL |
Special Employment Program
Default Value: 00
|
| 69 |
GVT_WGI_DUE_DATE |
Date(10) |
DATE |
Within-Grade Increase Due Date
|
| 70 |
GVT_DT_LEI |
Date(10) |
DATE |
Date Last Equivalent Increase
|
| 71 |
GVT_FIN_DISCLOSURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Disclosure Required
Y/N Table Edit
|
| 72 |
GVT_FIN_DISCL_DATE |
Date(10) |
DATE |
Financial Disclosure Due Date
|
| 73 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 74 |
GVT_DETL_BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
GVT Detail Bargaining Unit
|
| 75 |
GVT_DETL_UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
GVT Detail Union Code
|
| 76 |
NEXT_REVIEW_DT |
Date(10) |
DATE |
Next Review Date
|
| 77 |
GVT_WELFARE_WK_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Welfare to Work
Default Value: 00
|
| 78 |
TENURE_ACCR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TENURE_ACCR_FLG field used in the HCM/ CRM sync Application Messages.
Default Value: N
|
| 79 |
FTE_TENURE |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
This is the FTE tenure field.
|
| 80 |
EG_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Calculation Group
|
| 81 |
FTE_FLX_SRVC |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
This is the FTE flex service accrual field.
|
| 82 |
CONTRACT_LENGTH |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to store the contract length.
Default Value: 0
|
| 83 |
APPOINT_END_DT |
Date(10) |
DATE |
The end date of an appointment.
|
| 84 |
NEE_PROVIDER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The ID for the Non Employee Provider, Agency, or Employer.
|