POSITION_OS_VW

(SQL View)
 Index Back

Position Data

View to fetch position data withoutt security applied. Used for Index.

SELECT A.POSITION_NBR , A.EFFDT , A.EFFSEQ , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.ACTION , A.ACTION_REASON , A.ACTION_DT , A.BUSINESS_UNIT , A.DEPTID , A.JOBCODE , A.POSN_STATUS , A.STATUS_DT , A.BUDGETED_POSN , A.CONFIDENTIAL_POSN , A.KEY_POSITION , A.JOB_SHARE , A.MAX_HEAD_COUNT , A.UPDATE_INCUMBENTS , A.REPORTS_TO , A.REPORT_DOTTED_LINE , A.ORGCODE , A.ORGCODE_FLAG , A.LOCATION , A.MAIL_DROP , %subrec(PHONE_SBR, A) , A.COMPANY , A.STD_HOURS , A.STD_HRS_FREQUENCY , A.UNION_CD , 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 , %subrec(POS_DTA_FED_SBR, A) , A.REG_REGION , A.CLASS_INDC , A.ENCUMBER_INDC , A.FTE , A.POSITION_POOL_ID , A.EG_ACADEMIC_RANK , A.EG_GROUP , A.ENCUMB_SAL_OPTN , A.ENCUMB_SAL_AMT , A.HEALTH_CERTIFICATE , A.SIGN_AUTHORITY , A.ADDS_TO_FTE_ACTUAL , A.SAL_ADMIN_PLAN , A.GRADE , %subrec(POS_DTA_GER_SBR, A) , A.STEP , %subrec(POS_DTA_AUS_SBR, A) , A.SUPV_LVL_ID , A.INCLUDE_SALPLN_FLG , A.DESCRLONG , A.LASTUPDDTTM , A.LASTUPDOPRID , A.SEC_CLEARANCE_TYPE , A.MILITARY_SERVICE , A.MIL_SVC_COMP_CD , A.MIL_RANK , A.AVAIL_TELEWORK_POS , A.INCLUDE_TITLE , A.WF_STATUS , %subrec(POS_DTA_CAN_SBR, A) FROM PS_POSITION_DATA_E A

  • Related Language Record: POSN_OS_LANG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Default Value: 00000000

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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

    Default Value: POS

    Prompt Table: ACTION_TBL

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

    Prompt Table: ACTN_REASON_TBL

    9 ACTION_DT Date(10) DATE Action Date

    Default Value: %date

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

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUSUNIT_HR_VW

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: %EDITTABLE4

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

    Default Value: A

    14 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: 1

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

    Y/N Table Edit

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: POSITION_DATA

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

    Y/N Table Edit

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

    Prompt Table: LOCATION_TBL

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

    Default Value: DEPT_TBL.COMPANY

    Prompt Table: COMPANY_TBL

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

    Prompt Table: STDHRS_FREQ_VW

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

    Prompt Table: UNION_TBL

    33 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

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

    Default Value: JOBCODE_TBL.REG_TEMP

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

    Default Value: F

    36 MON_HRS Number(5,2) DECIMAL(4,2) NOT NULL Monday
    37 TUES_HRS Number(5,2) DECIMAL(4,2) NOT NULL Tuesday
    38 WED_HRS Number(5,2) DECIMAL(4,2) NOT NULL Wednesday
    39 THURS_HRS Number(5,2) DECIMAL(4,2) NOT NULL Thursday
    40 FRI_HRS Number(5,2) DECIMAL(4,2) NOT NULL Friday
    41 SAT_HRS Number(5,2) DECIMAL(4,2) NOT NULL Saturday
    42 SUN_HRS Number(5,2) DECIMAL(4,2) NOT NULL Sunday
    43 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

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

    Prompt Table: GVT_PAY_PLAN

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: TRN_PROGRM_TBL

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

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

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

    Prompt Table: GVT_SUBAGCY_TBL

    54 GVT_DT_POSN_ESTAB Date(10) DATE Date Position Established

    Default Value: %date

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

    Prompt Table: GVT_ORG_PSN_TTL

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

    Default Value: N

    60 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

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

    Default Value: N

    62 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: GVT_OCCUPATION

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

    Prompt Table: GVT_PERF_PLAN

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

    Prompt Table: GVT_POI_VW

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

    Default Value: H

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

    Prompt Table: PERSON_NAME

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

    Prompt Table: PERSON_NAME

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

    Default Value: N

    83 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

    84 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

    85 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

    86 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

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

    Prompt Table: GVT_SUBAGCY_VW

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: 00

    Prompt Table: GVT_CYBERSEC_CD

    97 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
    98 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
    99 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

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

    Default Value: C

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

    Default Value: I

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

    Prompt Table: POOL_TBL

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

    Prompt Table: EG_RANK_TBL

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

    Prompt Table: EG_CALC_SVC_VW

    106 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

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: %EDITTABLE

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

    Prompt Table: %EDITTABLE2

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

    Prompt Table: SAL_GRADE_TBL

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

    Prompt Table: SAL_STEP_FRM_VW

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

    Prompt Table: SAL_GRADE_TBL

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

    Prompt Table: SAL_STEP_TO_VW

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

    Prompt Table: %EDITTABLE3

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

    Prompt Table: PKG_TMP_TBL

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

    Prompt Table: PKG_RULE_TBL

    120 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system

    Prompt Table: SUPVSR_LVL_TBL

    121 INCLUDE_SALPLN_FLG Character(1) VARCHAR2(1) NOT NULL Include Salary Plan/Grade

    Y/N Table Edit

    Default Value: N

    122 DESCRLONG Long Character CLOB Long Description
    123 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    124 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    125 SEC_CLEARANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Security Clearance Type

    Prompt Table: SEC_CLR_TYP_TBL

    126 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service

    Prompt Table: MIL_SERVICE_TBL

    127 MIL_SVC_COMP_CD Character(4) VARCHAR2(4) NOT NULL Service Component

    Prompt Table: MIL_SVC_VW

    128 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank

    Prompt Table: MIL_RANK_TBL

    129 AVAIL_TELEWORK_POS Character(1) VARCHAR2(1) NOT NULL Position Available for Telework

    Y/N Table Edit

    Default Value: N

    130 INCLUDE_TITLE Character(1) VARCHAR2(1) NOT NULL Flag set to Update Incumbents when a Position Title change has been made.

    Y/N Table Edit

    Default Value: N

    131 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved
    132 ELS_STATUS Character(1) VARCHAR2(1) NOT NULL Employment and Labour Standards Status
    1=Exempt
    2=Non-Exempt

    Default Value: 2