POSNDEFT_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.

SELECT A.POSITION_NBR , A.EFFDT , A.DESCR , A.DESCRSHORT , A.BUSINESS_UNIT , A.DEPTID , A.JOBCODE , A.CONFIDENTIAL_POSN , A.KEY_POSITION , A.JOB_SHARE , A.MAX_HEAD_COUNT , A.REPORTS_TO , A.REPORT_DOTTED_LINE , A.LOCATION , A.MAIL_DROP , A.COMPANY , A.STD_HOURS , A.STD_HRS_FREQUENCY , A.SHIFT , A.REG_TEMP , A.FULL_PART_TIME , A.MON_HRS , A.TUES_HRS , A.WED_HRS , A.THURS_HRS , A.FRI_HRS , A.SAT_HRS , A.SUN_HRS , A.UNION_CD , %subrec(POS_DTA_FED_SBR,A) , A.REG_REGION , A.DESCRLONG , A.SAL_ADMIN_PLAN , A.GRADE , A.STEP ,A.FTE ,A.ADDS_TO_FTE_ACTUAL ,A.SEC_CLEARANCE_TYPE ,A.MILITARY_SERVICE ,A.MIL_SVC_COMP_CD ,A.MIL_RANK ,A.SUPV_LVL_ID FROM PS_POSITION_DATA A

  • Related Language Record: POSNDEFT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_TMP Character(8) VARCHAR2(8) NOT NULL Position Nbr Temp

    Default Value: 0

    2 EFFDT Date(10) DATE Effective Date
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_OPT_HR

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

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

    Y/N Table Edit

    Default Value: N

    9 KEY_POSITION Character(1) VARCHAR2(1) NOT NULL Key Position
    N=No
    Y=Yes

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: 1

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: LOCATION_TBL

    15 MAIL_DROP Character(50) VARCHAR2(50) NOT NULL Mail Drop ID
    16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    17 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    18 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
    19 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=Day
    2=Evening
    3=Night
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating

    Default Value: N

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

    Default Value: R

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

    Default Value: F

    22 MON_HRS Number(5,2) DECIMAL(4,2) NOT NULL Monday
    23 TUES_HRS Number(5,2) DECIMAL(4,2) NOT NULL Tuesday
    24 WED_HRS Number(5,2) DECIMAL(4,2) NOT NULL Wednesday
    25 THURS_HRS Number(5,2) DECIMAL(4,2) NOT NULL Thursday
    26 FRI_HRS Number(5,2) DECIMAL(4,2) NOT NULL Friday
    27 SAT_HRS Number(5,2) DECIMAL(4,2) NOT NULL Saturday
    28 SUN_HRS Number(5,2) DECIMAL(4,2) NOT NULL Sunday
    29 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
    30 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

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

    Prompt Table: GVT_PAY_PLAN

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: TRN_PROGRM_TBL

    34 LANGUAGE_SKILL Character(2) VARCHAR2(2) NOT NULL Language Required
    35 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
    36 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
    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

    37 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status
    38 GVT_STATUS_TYPE Character(3) VARCHAR2(3) NOT NULL Status Type
    CAN=Cancelled
    COM=Completed
    COR=Corrected
    IRR=IRR Reported
    WIP=Work-in-progress
    39 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
    R=Part-Time Phased Retiree
    S=Part-Time Job Sharer
    T=Part-Time Seasonal Job Sharer

    Default Value: F

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

    Prompt Table: GVT_SUBAGCY_TBL

    41 GVT_DT_POSN_ESTAB Date(10) DATE Date Position Established

    Default Value: %date

    42 GVT_COMP_AREA Character(2) VARCHAR2(2) NOT NULL Competitive Area
    43 GVT_COMP_LEVEL Character(4) VARCHAR2(4) NOT NULL Competitive Level
    44 GVT_ORG_TTL_CD Character(4) VARCHAR2(4) NOT NULL Organization Posn Title Code

    Prompt Table: GVT_ORG_PSN_TTL

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

    Default Value: N

    47 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

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

    Default Value: N

    49 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: GVT_OCCUPATION

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

    Prompt Table: GVT_PERF_PLAN

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

    Prompt Table: GVT_POI_VW

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

    Default Value: H

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

    Prompt Table: PERSON_NAME

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

    Prompt Table: PERSON_NAME

    66 GVT_OBLIG_EXPIR_DT Date(10) DATE Obligation expiration date.
    67 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade
    68 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
    69 GVT_EXEC_FIN_DISCL Character(1) VARCHAR2(1) NOT NULL Executive Financial Disclosure

    Default Value: N

    70 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

    71 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

    72 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 Reqd
    4=Position Title Change
    5=Occupational Series Change
    6=Position Upgrade
    7=Position Downgraded
    8=New Position
    9=Other

    Default Value: 0

    73 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

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

    Prompt Table: GVT_SUBAGCY_VW

    75 GVT_ORG_NUMCD1 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    76 GVT_ORG_NUMCD2 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    77 GVT_ORG_NUMCD3 Number(4,0) SMALLINT NOT NULL Federal NFC Field
    78 GVT_ORG_NUMCD4 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    79 GVT_ORG_NUMCD5 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    80 GVT_ORG_NUMCD6 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    81 GVT_ORG_NUMCD7 Number(2,0) SMALLINT NOT NULL Federal NFC Field
    82 GVT_NFC_PI_IND_OVR Character(1) VARCHAR2(1) NOT NULL Federal NFC Field

    Y/N Table Edit

    Default Value: N

    83 GVT_CYBER_SEC_CD Character(3) VARCHAR2(3) NOT NULL Cyber Security Category / Speciality Area

    Default Value: 00

    Prompt Table: GVT_CYBERSEC_CD

    84 GVT_PPM_JOB_IDENTY Character(1) VARCHAR2(1) NOT NULL Program and Project Management
    1=Program Manager
    2=Project Manager
    3=Program and Project Manager
    4=Not Applicable
    85 GVT_RW_TW_TYPE Character(2) VARCHAR2(2) NOT NULL Remote/Telework Type
    MW=Mobile Work Agreement
    NN=Non-teleworker
    RW=Remote Work Agreement
    TF=Frequent Routine Telework
    TP=Periodic Routine Telework
    TS=Situational Telework Agreement
    86 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

    87 DESCRLONG Long Character CLOB Long Description
    88 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    89 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    90 STEP Number(2,0) SMALLINT NOT NULL Step
    91 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    92 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count

    Y/N Table Edit

    Default Value: N

    93 SEC_CLEARANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Security Clearance Type
    94 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service
    95 MIL_SVC_COMP_CD Character(4) VARCHAR2(4) NOT NULL Service Component
    96 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank
    97 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system