GVT_PI_POMR_VW

(SQL View)
 Index Back

Gvt PI Position Master View


SELECT DISTINCT JC.JOBCODE ,98 ,JC.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 ,JC.GVT_DT_CLASSIFIED ,JC.GVT_PATCOB_CD ,JC.EFF_STATUS ,JC.EFFDT ,JC.GVT_CLASSIFIER_ID ,JC.GVT_PI_UPD_IND FROM PS_JOBCODE_TBL JC WHERE JC.EFFDT=( SELECT MAX(EFFDT) FROM PS_JOBCODE_TBL WHERE JOBCODE=JC.JOBCODE AND EFFDT<=%CurrentDateIn)

  • Related Language Record: GVT_PI_POMR_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 Record
    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_DT_CLASSIFIED Date(10) DATE Date Classified
    18 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
    19 GVT_EFF_STATUS Character(1) VARCHAR2(1) NOT NULL GVT Effective Status
    A=Active
    I=Inactive
    20 GVT_STATUS_DT Date(10) DATE Effective Status Date
    21 GVT_CLASSIFIER_ID Character(11) VARCHAR2(11) NOT NULL Classifier's ID
    22 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