GVT_PI_POIP_VW

(SQL View)
 Index Back

Gvt PI Position Detail View


SELECT DISTINCT PD.POSITION_NBR ,99 ,PD.EFFDT ,0 ,JC.COMPANY ,JC.GVT_SUB_AGENCY ,JC.GVT_POI ,JC.JOBCODE ,JC.GRADE ,JC.GVT_PAY_PLAN ,JC.GVT_OCC_SERIES ,JC.GVT_FUNC_CLASS ,JC.GVT_PAREN_TITLE ,JC.MANAGER_LEVEL ,JC.GVT_POSN_TITLE_CD ,JC.GVT_OFFICIAL_DESCR ,PD.GVT_POSN_LOC ,JC.GVT_DT_CLASSIFIED ,JC.GVT_PATCOB_CD ,JC.EFF_STATUS ,JC.EFFDT ,JC.GVT_CLASSIFIER_ID ,PD.ACTION_REASON ,PD.POSITION_NBR ,PD.FLSA_STATUS ,JC.GVT_EMP_FIN_INT ,JC.GVT_EXEC_FIN_DISCL ,PD.GVT_POSN_OCCUPIED ,PD.GVT_POSN_SENS_CD ,PD.GVT_PROC_INTEG_PSN ,PD.GVT_LEO_POSITION ,PD.SAL_ADMIN_PLAN ,PD.GVT_COMP_AREA ,PD.GVT_COMP_LEVEL ,PD.GVT_ORG_TTL_CD ,PD.GVT_ORG_TTL_DESCR ,PD.DEPTID ,PD.GVT_TARGET_GRADE ,PD.LOCATION ,PD.GVT_LAST_AUDIT_DT ,PD.BARG_UNIT ,PD.BUDGETED_POSN ,PD.LANGUAGE_SKILL ,PD.GVT_NTE_DATE ,PD.GVT_PRESIDENT_APPT ,PD.EFF_STATUS ,PD.GVT_DT_POSN_ESTAB ,PD.GVT_DRUG_TEST_REQ ,PD.GVT_PI_UPD_IND ,PD.GVT_WORK_SCHED ,LOC.GVT_GEOLOC_CD FROM PS_POSITION_DATA PD ,PS_JOBCODE_TBL JC ,PS_LOCATION_TBL LOC WHERE PD.JOBCODE=JC.JOBCODE AND JC.SETID=LOC.SETID AND JC.EFFDT=( SELECT MAX(EFFDT) FROM PS_JOBCODE_TBL WHERE JOBCODE = JC.JOBCODE AND EFFDT<=PD.EFFDT) AND PD.LOCATION = LOC.LOCATION AND LOC.EFFDT = ( SELECT MAX( EFFDT) FROM PS_LOCATION_TBL LOC2 WHERE PD.LOCATION = LOC2.LOCATION)

  • Related Language Record: GVT_PI_POIP_LNG

    • # 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 Rcd Nbr
    3 EFFDT Date(10) DATE Effective Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    6 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency
    7 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID
    8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    9 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    10 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    11 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    12 GVT_FUNC_CLASS Character(2) VARCHAR2(2) NOT NULL Functional Class
    00=Not Applicable
    11=Research
    12=Research,Contract/Grant Admin
    13=Development
    14=Test and Evaluation
    21=Design
    22=Construction
    23=Production
    24=Install/Operations/Maintenance
    31=Data Collect/Process/Analysis
    32=Scientific/Technical Info
    41=Standards and Specifications
    42=Regulatory Enforcement/License
    51=Natural Resource Operations
    81=Clinical Practice/Counseling
    91=Planning
    92=Management
    93=Teaching/Training
    94=Technical Assistance/Consult
    99=Other
    13 GVT_PAREN_TITLE Character(1) VARCHAR2(1) NOT NULL Parenthetical Title
    D=(Data Transcribing)
    O=(Office Automation)
    S=(Stenography)
    T=(Typing)
    14 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
    0=Chief Operating Officer
    1=Director
    2=Senior Officer
    3=Vice President
    4=Senior Manager
    5=Mid-Level Manager
    6=First-Line Manager
    7=Supervisor
    8=All Other Positions
    9=Non-Manager
    15 GVT_POSN_TITLE_CD Character(4) VARCHAR2(4) NOT NULL Official Posn Title Code
    16 GVT_OFFICIAL_DESCR Character(70) VARCHAR2(70) NOT NULL Official Position Title
    17 GVT_POSN_LOC Character(1) VARCHAR2(1) NOT NULL Position Location
    F=Field
    H=Headquarters
    18 GVT_DT_CLASSIFIED Date(10) DATE Date Classified
    19 GVT_PATCOB_CD Character(1) VARCHAR2(1) NOT NULL PATCOB Code
    1=Exception 1
    2=Exception 2
    3=Exception 3
    4=Exception 4
    5=Exception 5
    6=Exception 6
    7=Exception 7
    8=Exception 8
    A=Administrative
    B=Blue Collar
    C=Clerical
    M=Mixed Collar
    O=Other White Collar
    P=Professional
    T=Technical
    20 GVT_EFF_STATUS Character(1) VARCHAR2(1) NOT NULL GVT Effective Status
    A=Active
    I=Inactive
    21 GVT_STATUS_DT Date(10) DATE Effective Status Date
    22 GVT_CLASSIFIER_ID Character(11) VARCHAR2(11) NOT NULL Classifier's ID
    23 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
    24 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    25 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status field
    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
    26 GVT_EMP_FIN_INT Character(1) VARCHAR2(1) NOT NULL Employee Financial Interests
    27 GVT_EXEC_FIN_DISCL Character(1) VARCHAR2(1) NOT NULL Executive Financial Disclosure
    28 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
    1=Competitive
    2=Excepted
    3=SES General
    4=SES Career Reserved
    29 GVT_POSN_SENS_CD Character(1) VARCHAR2(1) NOT NULL Sensitivity Code
    1=Non Sensitive
    2=Non-Critical, Sensitive
    3=Critical Sensitive
    4=Special Sensitive
    30 GVT_PROC_INTEG_PSN Character(1) VARCHAR2(1) NOT NULL Procurement Integ Posn
    31 GVT_LEO_POSITION Character(1) VARCHAR2(1) NOT NULL LEO/Fire Position
    5=5USC 5305 LEO
    C=D.C. Police Forces
    F=Fire Fighter
    N=Not Applicable
    P=Primary FEPCA
    S=Secondary FEPCA
    32 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    33 GVT_COMP_AREA Character(2) VARCHAR2(2) NOT NULL Competitive Area
    34 GVT_COMP_LEVEL Character(4) VARCHAR2(4) NOT NULL Competitive Level
    35 GVT_ORG_TTL_CD Character(4) VARCHAR2(4) NOT NULL Organization Posn Title Cd
    36 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    37 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    38 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade
    39 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    40 GVT_LAST_AUDIT_DT Date(10) DATE Position Audit Date
    41 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2
    42 BUDGETED_POSN Character(1) VARCHAR2(1) NOT NULL Budgeted Position
    43 LANGUAGE_SKILL Character(2) VARCHAR2(2) NOT NULL Language Required
    44 GVT_NTE_DATE Date(10) DATE Not To Exceed Date
    45 GVT_PRESIDENT_APPT Character(1) VARCHAR2(1) NOT NULL Presidential Appt Posn
    46 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    47 GVT_DT_POSN_ESTAB Date(10) DATE Date Position Established
    48 GVT_DRUG_TEST_REQ Character(1) VARCHAR2(1) NOT NULL Drug Test (Applicable)
    49 GVT_PI_UPD_IND Character(1) VARCHAR2(1) NOT NULL PI upd ind
    A=Applied at NFC
    I=Auto Action Inserted
    N=Not Ready to Process
    P=In Process
    R=Ready To Process
    S=SINQ Error
    Z=Other
    50 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
    S=Part-Time Job Sharer
    T=Part-Time Seasonal Job Sharer
    51 GVT_GEOLOC_CD Character(9) VARCHAR2(9) NOT NULL Geog Location Code