POS_DATA_EF_VW

(SQL View)
 Index Back

Position Data

POSITION_DATA is the main data record for the Position Management application. It is also used in Succession Planning to establish key positions. If Position Management is installed, data contained in LIKE field names is copied across to the Job record as Position Data changes. /* PLEASE NOTE: The PeopleCode currently on ADDS_TO_FTE.SaveEdit MUST be located on the last data field on the record. If you modify Position Management, new fields must be added above this logic, or the logic moved accordingly. */

SELECT POSITION_NBR , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , ACTION , ACTION_REASON , ACTION_DT , BUSINESS_UNIT , DEPTID , JOBCODE , POSN_STATUS , STATUS_DT , BUDGETED_POSN , CONFIDENTIAL_POSN , KEY_POSITION , JOB_SHARE , MAX_HEAD_COUNT , UPDATE_INCUMBENTS , REPORTS_TO , REPORT_DOTTED_LINE , ORGCODE , ORGCODE_FLAG , LOCATION , MAIL_DROP , COUNTRY_CODE , PHONE , COMPANY , STD_HOURS , STD_HRS_FREQUENCY , UNION_CD , SHIFT , REG_TEMP , FULL_PART_TIME , MON_HRS , TUES_HRS , WED_HRS , THURS_HRS , FRI_HRS , SAT_HRS , SUN_HRS , BARG_UNIT , GVT_PAY_PLAN , SEASONAL , TRN_PROGRAM , LANGUAGE_SKILL , MANAGER_LEVEL , FLSA_STATUS , GVT_WIP_STATUS , GVT_STATUS_TYPE , GVT_WORK_SCHED , GVT_SUB_AGENCY , GVT_DT_POSN_ESTAB , GVT_COMP_AREA , GVT_COMP_LEVEL , GVT_ORG_TTL_CD , GVT_ORG_TTL_DESCR , GVT_DRUG_TEST_REQ , GVT_FUND_SOURCE , GVT_INTEL_POSN , GVT_LEO_POSITION , GVT_MOB_POSN_IND , GVT_PROC_INTEG_PSN , GVT_PRESIDENT_APPT , GVT_NTE_DATE , GVT_OCC_SERIES , GVT_PAR_NBR , GVT_PAREN_TITLE , GVT_PERF_PLAN , GVT_POI , GVT_POSN_LOC , GVT_POSN_OCCUPIED , GVT_POSN_SENS_CD , GVT_STAFF_LINE , GVT_LAST_AUDIT_DT , GVT_AUDITED_BY_ID , GVT_OBLIGATED_TO , GVT_OBLIG_EXPIR_DT , GVT_TARGET_GRADE , GVT_PI_UPD_IND ,GVT_EXEC_FIN_DISCL ,GVT_NFC_FUNCTN_CD ,GVT_MAINT_REVIEWCD ,GVT_MANTREV_RESULT ,GVT_VACY_REVW_CD ,GVT_ORG_SUBAGENCY ,GVT_ORG_NUMCD1 ,GVT_ORG_NUMCD2 ,GVT_ORG_NUMCD3 ,GVT_ORG_NUMCD4 ,GVT_ORG_NUMCD5 ,GVT_ORG_NUMCD6 ,GVT_ORG_NUMCD7 ,GVT_NFC_PI_IND_OVR , REG_REGION , CLASS_INDC , ENCUMBER_INDC , FTE , POSITION_POOL_ID , EG_ACADEMIC_RANK , EG_GROUP , ENCUMB_SAL_OPTN , ENCUMB_SAL_AMT , HEALTH_CERTIFICATE , SIGN_AUTHORITY , ADDS_TO_FTE_ACTUAL , SAL_ADMIN_PLAN , GRADE , GRADE_FROM , STEP_FROM , GRADE_TO , STEP_TO , STEP , PKG_TEMPLATE_ID , PKG_RULE_ID , DESCRLONG , SEC_CLEARANCE_TYPE FROM PS_POSITION_DATA POS WHERE POS.EFFDT = ( SELECT MAX(EFFDT) FROM PS_POSITION_DATA WHERE POSITION_NBR = POS.POSITION_NBR AND EFFDT <= %CurrentDateIn)

  • Related Language Record: POSN_DATA_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Default Value: POS

    Prompt Table: ACTION_TBL

    7 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    8 ACTION_DT Date(10) DATE Action Date

    Default Value: %date

    9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

    10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    11 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: %RECNAME_EDIT

    12 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
    A=Approved
    P=Proposed
    R=Frozen

    Default Value: A

    13 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    14 BUDGETED_POSN Character(1) VARCHAR2(1) NOT NULL Budgeted Position

    Y/N Table Edit

    Default Value: Y

    15 CONFIDENTIAL_POSN Character(1) VARCHAR2(1) NOT NULL Confidential Position

    Y/N Table Edit

    Default Value: N

    16 KEY_POSITION Character(1) VARCHAR2(1) NOT NULL Key Position

    Y/N Table Edit

    Default Value: N

    17 JOB_SHARE Character(1) VARCHAR2(1) NOT NULL Job Sharing Permitted

    Y/N Table Edit

    Default Value: N

    18 MAX_HEAD_COUNT Number(4,0) SMALLINT NOT NULL Max Head Count

    Default Value: 1

    19 UPDATE_INCUMBENTS Character(1) VARCHAR2(1) NOT NULL Update Incumbents

    Y/N Table Edit

    20 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

    Prompt Table: POSITION_DATA

    21 REPORT_DOTTED_LINE Character(8) VARCHAR2(8) NOT NULL Dotted-Line Report

    Prompt Table: POSITION_DATA

    22 ORGCODE Character(60) VARCHAR2(60) NOT NULL Organization Hierarchy Code
    23 ORGCODE_FLAG Character(1) VARCHAR2(1) NOT NULL Organization Hierarchy Flag

    Y/N Table Edit

    24 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    25 MAIL_DROP Character(50) VARCHAR2(50) NOT NULL Mail Drop ID
    26 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    27 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    28 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Default Value: DEPT_TBL.COMPANY

    Prompt Table: COMPANY_TBL

    29 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    30 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

    Prompt Table: STDHRS_FREQ_VW

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

    Prompt Table: UNION_TBL

    32 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=1
    2=2
    3=3
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating

    Default Value: N

    33 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary

    Default Value: JOBCODE_TBL.REG_TEMP

    34 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time

    Default Value: F

    35 MON_HRS Number(5,2) DECIMAL(4,2) NOT NULL Monday
    36 TUES_HRS Number(5,2) DECIMAL(4,2) NOT NULL Tuesday
    37 WED_HRS Number(5,2) DECIMAL(4,2) NOT NULL Wednesday
    38 THURS_HRS Number(5,2) DECIMAL(4,2) NOT NULL Thursday
    39 FRI_HRS Number(5,2) DECIMAL(4,2) NOT NULL Friday
    40 SAT_HRS Number(5,2) DECIMAL(4,2) NOT NULL Saturday
    41 SUN_HRS Number(5,2) DECIMAL(4,2) NOT NULL Sunday
    42 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2

    Default Value: 8888

    Prompt Table: GVT_BARG_UNIT

    43 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

    Prompt Table: GVT_PAY_PLAN

    44 SEASONAL Character(1) VARCHAR2(1) NOT NULL Seasonal

    Y/N Table Edit

    Default Value: N

    45 TRN_PROGRAM Character(6) VARCHAR2(6) NOT NULL Training Program

    Prompt Table: TRN_PROGRM_TBL

    46 LANGUAGE_SKILL Character(2) VARCHAR2(2) NOT NULL Language Required
    47 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
    48 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

    Default Value: N

    49 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status
    50 GVT_STATUS_TYPE Character(3) VARCHAR2(3) NOT NULL Status Type
    CAN=Cancelled
    COM=Completed
    COR=Corrected
    IRR=IRR Reported
    WIP=Work-in-progress
    51 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

    Default Value: F

    52 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

    Prompt Table: GVT_SUBAGCY_TBL

    53 GVT_DT_POSN_ESTAB Date(10) DATE Date Position Established

    Default Value: %date

    54 GVT_COMP_AREA Character(2) VARCHAR2(2) NOT NULL Competitive Area
    55 GVT_COMP_LEVEL Character(4) VARCHAR2(4) NOT NULL Competitive Level
    56 GVT_ORG_TTL_CD Character(4) VARCHAR2(4) NOT NULL Organization Posn Title Cd

    Prompt Table: GVT_ORG_PSN_TTL

    57 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    58 GVT_DRUG_TEST_REQ Character(1) VARCHAR2(1) NOT NULL Drug Test (Applicable)

    Default Value: N

    59 GVT_FUND_SOURCE Character(1) VARCHAR2(1) NOT NULL Fund Source
    A=Appropriated Funds
    E=External Funds
    N=Non-Appropriated Funds
    O=Other Funds

    Default Value: A

    60 GVT_INTEL_POSN Character(1) VARCHAR2(1) NOT NULL Intelligence Position

    Default Value: N

    61 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

    Default Value: N

    62 GVT_MOB_POSN_IND Character(1) VARCHAR2(1) NOT NULL Mobility Position

    Y/N Table Edit

    Default Value: N

    63 GVT_PROC_INTEG_PSN Character(1) VARCHAR2(1) NOT NULL Procurement Integ Posn

    Y/N Table Edit

    Default Value: N

    64 GVT_PRESIDENT_APPT Character(1) VARCHAR2(1) NOT NULL Presidential Appt Posn

    Y/N Table Edit

    Default Value: N

    65 GVT_NTE_DATE Date(10) DATE Not To Exceed Date
    66 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series

    Prompt Table: GVT_OCCUPATION

    67 GVT_PAR_NBR Character(15) VARCHAR2(15) NOT NULL Personnel Action Request Nbr
    68 GVT_PAREN_TITLE Character(1) VARCHAR2(1) NOT NULL Parenthetical Title
    D=(Data Transcribing)
    O=(Office Automation)
    S=(Stenography)
    T=(Typing)
    69 GVT_PERF_PLAN Character(8) VARCHAR2(8) NOT NULL Performance Plan

    Prompt Table: GVT_PERF_PLAN

    70 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID

    Prompt Table: GVT_POI_VW

    71 GVT_POSN_LOC Character(1) VARCHAR2(1) NOT NULL Position Location
    F=Field
    H=Headquarters

    Default Value: H

    72 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
    1=Competitive
    2=Excepted
    3=SES General
    4=SES Career Reserved
    73 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
    74 GVT_STAFF_LINE Character(1) VARCHAR2(1) NOT NULL Staff/Line Position
    75 GVT_LAST_AUDIT_DT Date(10) DATE Position Audit Date
    76 GVT_AUDITED_BY_ID Character(11) VARCHAR2(11) NOT NULL Position Audited By

    Prompt Table: PERSON_NAME

    77 GVT_OBLIGATED_TO Character(11) VARCHAR2(11) NOT NULL Obligated To ID

    Prompt Table: PERSON_NAME

    78 GVT_OBLIG_EXPIR_DT Date(10) DATE Obligation Expiration
    79 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade
    80 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
    81 GVT_EXEC_FIN_DISCL Character(1) VARCHAR2(1) NOT NULL Executive Financial Disclosure

    Default Value: N

    82 GVT_NFC_FUNCTN_CD Character(2) VARCHAR2(2) NOT NULL Federal NFC field
    A=Add
    C=Change
    D=Delete/Restore
    I=Inactivate
    R=Reactivate

    Default Value: A

    83 GVT_MAINT_REVIEWCD Character(2) VARCHAR2(2) NOT NULL Federal field used by position data
    0=None
    1=Desk Audit, Normal Review
    2=Suprvsry Audit,Normal Review
    3=Paper Review, Normal Review
    4=PME/Activity Review
    5=Desk Audit, Maintenance Rev
    6=Suprvsry Audit,Maintenance Rev
    7=Paper Review,Maintenance Rev
    8=Panel Review,Maintenance Rev

    Default Value: 0

    84 GVT_MANTREV_RESULT Character(2) VARCHAR2(2) NOT NULL Field used by federal customers on position data
    0=None
    1=No Action Required
    2=Minor Description Changes
    3=Rewrite of Position Descr Req
    4=Position Title Change
    5=Occupational Series Change
    6=Position Upgrade
    7=Position Downgraded
    8=New Position
    9=Other

    Default Value: 0

    85 GVT_VACY_REVW_CD Character(2) VARCHAR2(2) NOT NULL Federal field on position data
    0=Position Action No Vacancy
    A=No Change
    B=Lower Grade
    C=Higher Grade
    D=Diff Title and/or Series
    E=New Position/New FTE

    Default Value: 0

    86 GVT_ORG_SUBAGENCY Character(2) VARCHAR2(2) NOT NULL Federal field used in Position Data

    Prompt Table: GVT_SUBAGCY_VW

    87 GVT_ORG_NUMCD1 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    88 GVT_ORG_NUMCD2 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    89 GVT_ORG_NUMCD3 Number(4,0) SMALLINT NOT NULL Federal NFC Field
    90 GVT_ORG_NUMCD4 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    91 GVT_ORG_NUMCD5 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    92 GVT_ORG_NUMCD6 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    93 GVT_ORG_NUMCD7 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    94 GVT_NFC_PI_IND_OVR Character(1) VARCHAR2(1) NOT NULL Federal NFC Field

    Y/N Table Edit

    Default Value: N

    95 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

    96 CLASS_INDC Character(1) VARCHAR2(1) NOT NULL Classified/Unclassified Indc
    B=All
    C=Classified
    T=Temporary
    U=Unclassified

    Default Value: C

    97 ENCUMBER_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Indicator
    I=Encumber Immediately
    N=No Encumbrance
    R=Encumber on Requisition

    Default Value: I

    98 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    99 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID

    Prompt Table: POOL_TBL

    100 EG_ACADEMIC_RANK Character(3) VARCHAR2(3) NOT NULL Academic Rank

    Prompt Table: EG_RANK_TBL

    101 EG_GROUP Character(6) VARCHAR2(6) NOT NULL Service Calculation Group

    Prompt Table: EG_CALC_GRP_TBL

    102 ENCUMB_SAL_OPTN Character(3) VARCHAR2(3) NOT NULL Encumber Salary Option
    COM=Sum of Default Components
    MAX=Salary Grade Maximum
    MID=Salary Grade Midpoint
    MIN=Salary Grade Minimum
    STP=Salary Step
    USR=User Specified Amount

    Default Value: STP

    103 ENCUMB_SAL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Encumber Salary Amount
    104 HEALTH_CERTIFICATE Character(1) VARCHAR2(1) NOT NULL Health Certificate
    1=Full Health Check
    2=Eye Check
    3=Ear Check
    4=Radiation Check
    105 SIGN_AUTHORITY Character(1) VARCHAR2(1) NOT NULL Signature Authority
    1=Credit Competence
    2=Signature Competence
    3=Procuration
    106 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count

    Y/N Table Edit

    Default Value: N

    107 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: %EDITTABLE

    108 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: %EDITTABLE2

    109 GRADE_FROM Character(3) VARCHAR2(3) NOT NULL From Grade

    Prompt Table: SAL_GRADE_TBL

    110 STEP_FROM Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: SAL_STEP_FRM_VW

    111 GRADE_TO Character(3) VARCHAR2(3) NOT NULL To Grade

    Prompt Table: SAL_GRADE_TBL

    112 STEP_TO Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: SAL_STEP_TO_VW

    113 STEP Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: %EDITTABLE3

    114 PKG_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Sal Package - Package Template ID

    Prompt Table: PKG_TMP_TBL

    115 PKG_RULE_ID Character(10) VARCHAR2(10) NOT NULL Sal Package - Package Rule ID

    Prompt Table: PKG_RULE_TBL

    116 DESCRLONG Long Character CLOB Long Description
    117 SEC_CLEARANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Security Clearance Type