GVT_CURR_EMPLMT

(SQL View)
 Index Back

EE Current Employment Data Vw

EMPLOYMENT is one of the core records in the database. Use it to record an employee's employment-related data that doesn't tend to change, such as hire date, termination date, and company service date. Many changes have been made for the US Federal Government.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.BENEFIT_RCD_NBR , A.HOME_HOST_CLASS , A.HIRE_DT , A.REHIRE_DT , A.SERVICE_DT , A.PROF_EXPERIENCE_DT , A.LAST_VERIFICATN_DT , A.CMPNY_SENIORITY_DT , A.GVT_SCD_RETIRE , A.GVT_SCD_TSP , A.GVT_SCD_LEO , A.GVT_SCD_SEVPAY , A.GVT_SEVPAY_PRV_WKS , A.TERMINATION_DT , A.GVT_MAND_RET_DT , A.LAST_DATE_WORKED , A.LAST_INCREASE_DT , A.GVT_WGI_STATUS , A.GVT_INTRM_DAYS_WGI , A.GVT_NONPAY_NOA , A.EXPECTED_RETURN_DT , A.GVT_NONPAY_HRS_WGI , A.GVT_NONPAY_HRS_SCD , A.GVT_NONPAY_HRS_TNR , A.GVT_NONPAY_HRS_PRB , A.GVT_TEMP_PRO_EXPIR , A.GVT_TEMP_PSN_EXPIR , A.GVT_DETAIL_EXPIRES , A.GVT_SABBATIC_EXPIR , A.GVT_RTND_GRADE_BEG , A.GVT_RTND_GRADE_EXP , A.OWN_5PERCENT_CO , A.BUSINESS_TITLE , A.GVT_NOA_CODE , A.GVT_CURR_APT_AUTH1 , A.GVT_CURR_APT_AUTH2 , A.GVT_APPT_EXPIR_DT , A.GVT_CNV_BEGIN_DATE , A.GVT_CAREER_CNV_DUE , A.GVT_CAREER_COND_DT , A.GVT_APPT_LIMIT_HRS , A.GVT_APPT_LIMIT_DYS , A.GVT_APPT_LIMIT_AMT , B.BARG_UNIT , B.UNION_CD , B.UNION_SENIORITY_DT , A.PROBATION_DT , A.GVT_SUPV_PROB_DT , A.GVT_SES_PROB_DT , A.GVT_ERN_PGM_PERM , A.GVT_OCC_SERS_PERM , A.GVT_GRADE_PERM , A.GVT_COMP_AREA_PERM , A.GVT_COMP_LVL_PERM , A.DED_TAKEN , A.DED_SUBSET_ID , A.NEXT_REVIEW_DT , A.GVT_CHANGE_FLAG , A.GVT_SPEP , A.GVT_WGI_DUE_DATE , A.GVT_DT_LEI , A.GVT_FIN_DISCLOSURE , A.GVT_FIN_DISCL_DATE , A.GVT_TENURE , A.POSITION_PHONE FROM PS_GVT_EMPLOYMENT A , PS_GVT_JOB B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GVT_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT <= %CurrentDateIn AND GVT_STATUS_TYPE IN ('COM', 'COR')) AND B.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_GVT_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT = B.EFFDT AND GVT_STATUS_TYPE IN ('COM', 'COR'))

  • Related Language Record: GVT_CURT_LNG_VW

    • # 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 Record
    3 EFFDT Date(10) DATE 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
    7 HIRE_DT Date(10) DATE First Start Date
    8 REHIRE_DT Date(10) DATE Rehire Date
    9 SERVICE_DT Date(10) DATE Service Date
    10 PROF_EXPERIENCE_DT Date(10) DATE Professional Experience Date
    11 LAST_VERIFICATN_DT Date(10) DATE Last Verification Date
    12 CMPNY_SENIORITY_DT Date(10) DATE Company Seniority Date
    13 GVT_SCD_RETIRE Date(10) DATE Service Comp Date - Retire
    14 GVT_SCD_TSP Date(10) DATE Service Comp Date - TSP
    15 GVT_SCD_LEO Date(10) DATE Service Comp Date - LEO
    16 GVT_SCD_SEVPAY Date(10) DATE Service Comp Date - Sev Pay
    17 GVT_SEVPAY_PRV_WKS Number(2,0) SMALLINT NOT NULL Severance Pay Previous Weeks
    18 TERMINATION_DT Date(10) DATE Termination Date
    19 GVT_MAND_RET_DT Date(10) DATE Mandatory Retirement Date
    20 LAST_DATE_WORKED Date(10) DATE Last Date Worked
    21 LAST_INCREASE_DT Date(10) DATE Date Last Increase
    22 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

    23 GVT_INTRM_DAYS_WGI Number(3,0) SMALLINT NOT NULL Intermittent Days Worked
    24 GVT_NONPAY_NOA Character(3) VARCHAR2(3) NOT NULL NonPay Nature of Action - Last

    Prompt Table: GVT_NOAC_TBL

    25 EXPECTED_RETURN_DT Date(10) DATE Expected Return Date
    26 GVT_NONPAY_HRS_WGI Number(7,2) DECIMAL(6,2) NOT NULL Non-Pay Hours WGI
    27 GVT_NONPAY_HRS_SCD Number(7,2) DECIMAL(6,2) NOT NULL Non-Pay Hours for SCD
    28 GVT_NONPAY_HRS_TNR Number(7,2) DECIMAL(6,2) NOT NULL Career Tenure Hours
    29 GVT_NONPAY_HRS_PRB Number(7,2) DECIMAL(6,2) NOT NULL Non-Pay Hours for Probation
    30 GVT_TEMP_PRO_EXPIR Date(10) DATE Temp Promotion Expires
    31 GVT_TEMP_PSN_EXPIR Date(10) DATE Temporary Posn Change Expires
    32 GVT_DETAIL_EXPIRES Date(10) DATE Date Detail Expires
    33 GVT_SABBATIC_EXPIR Date(10) DATE Date Sabbatical Expires
    34 GVT_RTND_GRADE_BEG Date(10) DATE Retained Grade Begins
    35 GVT_RTND_GRADE_EXP Date(10) DATE Retained Grade Expires
    36 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

    37 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
    38 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
    39 GVT_CURR_APT_AUTH1 Character(3) VARCHAR2(3) NOT NULL Current Appointment Auth Nbr 1

    Prompt Table: GVT_LEGAL_AUTH

    40 GVT_CURR_APT_AUTH2 Character(3) VARCHAR2(3) NOT NULL Current Appointment Auth Nbr 2

    Prompt Table: GVT_LEGAL_AUTH

    41 GVT_APPT_EXPIR_DT Date(10) DATE Appointment Expiration Date
    42 GVT_CNV_BEGIN_DATE Date(10) DATE Conv Begin Date
    43 GVT_CAREER_CNV_DUE Date(10) DATE Conversion To Career Due
    44 GVT_CAREER_COND_DT Date(10) DATE Career Cond Conversion Date
    45 GVT_APPT_LIMIT_HRS Number(4,0) SMALLINT NOT NULL Appointment Limit in Hours
    46 GVT_APPT_LIMIT_DYS Number(3,0) SMALLINT NOT NULL Appointment Limit in Days
    47 GVT_APPT_LIMIT_AMT Number(6,0) INTEGER NOT NULL Appointment Limit Amount
    48 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2

    Prompt Table: GVT_BARG_UNIT

    49 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

    Prompt Table: UNION_TBL

    50 UNION_SENIORITY_DT Date(10) DATE Union Seniority Date
    51 PROBATION_DT Date(10) DATE Probation Date
    52 GVT_SUPV_PROB_DT Date(10) DATE Supv/Manager Probation Date
    53 GVT_SES_PROB_DT Date(10) DATE SES Probation Date
    54 GVT_ERN_PGM_PERM Character(2) VARCHAR2(2) NOT NULL Permanent Pay Plan - RIF

    Prompt Table: ERN_PROGRAM_TBL

    55 GVT_OCC_SERS_PERM Character(4) VARCHAR2(4) NOT NULL Permanent Occ Series - RIF

    Prompt Table: GVT_OCCUPATION

    56 GVT_GRADE_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Grade - RIF
    57 GVT_COMP_AREA_PERM Character(2) VARCHAR2(2) NOT NULL Comp/Area Level
    58 GVT_COMP_LVL_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Comp Level - RIF
    59 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

    60 DED_SUBSET_ID Character(3) VARCHAR2(3) NOT NULL Deduction Subset ID

    Prompt Table: DED_SUBSET_TBL

    61 NEXT_REVIEW_DT Date(10) DATE Next Review Date
    62 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag

    Y/N Table Edit

    Default Value: N

    63 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

    64 GVT_WGI_DUE_DATE Date(10) DATE Within-Grade Increase Due Date
    65 GVT_DT_LEI Date(10) DATE Date Last Equivalent Increase
    66 GVT_FIN_DISCLOSURE Character(1) VARCHAR2(1) NOT NULL Financial Disclosure Required

    Y/N Table Edit

    67 GVT_FIN_DISCL_DATE Date(10) DATE Financial Disclosure Due Date
    68 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
    0=None
    1=Permanent
    2=Conditional
    3=Indefinite
    69 POSITION_PHONE Character(24) VARCHAR2(24) NOT NULL Phone number for the Position