POSN_NOEFFDT_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 ,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 ,SAL_ADMIN_PLAN ,GRADE ,STEP ,ADDS_TO_FTE_ACTUAL ,GRADE_FROM ,STEP_FROM ,GRADE_TO ,STEP_TO ,DESCRLONG ,SUPV_LVL_ID ,SEC_CLEARANCE_TYPE A FROM PS_POSITION_DATA A WHERE A.FULL_PART_TIME <> 'D' AND A.STD_HOURS > 0 AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_POSITION_DATA A1 WHERE A1.POSITION_NBR = A.POSITION_NBR AND EFF_STATUS = 'A') AND NOT EXISTS ( SELECT 'X' FROM PS_POSITION_DATA A2 WHERE A2.POSITION_NBR = A.POSITION_NBR AND A2.EFF_STATUS = 'I' AND A2.EFFDT > A.EFFDT AND A2.EFFDT <= %CurrentDateIn)

  • Related Language Record: POSN_NOEFDT_LNG
  • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Default Value: POS

    Prompt Table: ACTION_TBL

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

    Prompt Table: ACTN_REASON_TBL

    6 ACTION_DT Date(10) DATE Action Date

    Default Value: %date

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

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: %RECNAME_EDIT

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

    Default Value: A

    11 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: 1

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

    Y/N Table Edit

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: POSITION_DATA

    20 ORGCODE Character(60) VARCHAR2(60) NOT NULL Organization Hierarchy Code
    21 ORGCODE_FLAG Character(1) VARCHAR2(1) NOT NULL Organization Hierarchy Flag

    Y/N Table Edit

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

    Prompt Table: LOCATION_TBL

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

    Default Value: DEPT_TBL.COMPANY

    Prompt Table: COMPANY_TBL

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

    Prompt Table: STDHRS_FREQ_VW

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

    Prompt Table: UNION_TBL

    30 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

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

    Default Value: JOBCODE_TBL.REG_TEMP

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

    Default Value: F

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

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

    Prompt Table: GVT_PAY_PLAN

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: TRN_PROGRM_TBL

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

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

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

    Prompt Table: GVT_SUBAGCY_TBL

    51 GVT_DT_POSN_ESTAB Date(10) DATE Date Position Established

    Default Value: %date

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

    Prompt Table: GVT_ORG_PSN_TTL

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

    Default Value: N

    57 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

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

    Default Value: N

    59 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: GVT_OCCUPATION

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

    Prompt Table: GVT_PERF_PLAN

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

    Prompt Table: GVT_POI_VW

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

    Default Value: H

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

    Prompt Table: PERSON_NAME

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

    Prompt Table: PERSON_NAME

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

    Default Value: N

    80 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

    81 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

    82 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

    83 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

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

    Prompt Table: GVT_SUBAGCY_VW

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

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

    Default Value: C

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

    Default Value: I

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

    Prompt Table: POOL_TBL

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

    Prompt Table: EG_RANK_TBL

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

    Prompt Table: EG_CALC_GRP_TBL

    100 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

    101 ENCUMB_SAL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Encumber Salary Amount
    102 HEALTH_CERTIFICATE Character(1) VARCHAR2(1) NOT NULL Health Certificate
    1=Full Health Check
    2=Eye Check
    3=Ear Check
    4=Radiation Check
    103 SIGN_AUTHORITY Character(1) VARCHAR2(1) NOT NULL Signature Authority
    1=Credit Competence
    2=Signature Competence
    3=Procuration
    104 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: %EDITTABLE2

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

    Prompt Table: %EDITTABLE3

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

    Prompt Table: %EDITTABLE4

    107 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: SAL_GRADE_TBL

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

    Prompt Table: SAL_STEP_TBL

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

    Prompt Table: SAL_GRADE_TBL

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

    Prompt Table: SAL_STEP_TBL

    112 DESCRLONG Long Character CLOB Long Description
    113 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system
    114 SEC_CLEARANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Security Clearance Type