HP_BDCK_POS_VW

(SQL View)
 Index Back

Budget Check for Position view

Budget check view for position

SELECT P.POSITION_NBR , PD.DESCR , PD.DEPTID , PD.COMPANY , P.HP_BUDGET_STATUS , P.HP_CRITICAL_TXN , P.HP_RTBC_TRIGGER , P.HP_RTBC_PERFORMED , P.HP_UPD_IN_PROGRESS , P.HP_LSTUPD_ENC_TIME FROM PS_HP_BDCK_LOG_POS P , PS_POSITION_DATA PD WHERE P.POSITION_NBR = PD.POSITION_NBR AND PD.EFFDT = ( SELECT MAX(PD1.EFFDT) FROM PS_POSITION_DATA PD1 WHERE PD1.POSITION_NBR = P.POSITION_NBR AND PD1.EFFDT <= %CurrentDateIn)

  • Related Language Record: HP_BDCK_PN_L_VW

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

    Prompt Table: POSITION_DATA

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    5 HP_BUDGET_STATUS Character(1) VARCHAR2(1) NOT NULL Commitment Control budget status
    I=Invalid
    P=Pending
    V=Valid
    X=Never Encumbered
    6 HP_CRITICAL_TXN Character(1) VARCHAR2(1) NOT NULL Critical Transaction indicator
    7 HP_RTBC_TRIGGER Character(1) VARCHAR2(1) NOT NULL RTBC Triggered indicator
    B=Batch
    J=Job Component
    L=Initial Load
    P=Position Component
    R=Real Time
    8 HP_RTBC_PERFORMED Character(1) VARCHAR2(1) NOT NULL RTBC Performed indicator
    9 HP_UPD_IN_PROGRESS Character(1) VARCHAR2(1) NOT NULL This field is to indicate if update is in progress for a particular Doc ID. If it is "Yes", then the Doc ID is locked until the update is completed.
    10 HP_LSTUPD_ENC_TIME DateTime(26) TIMESTAMP Last Encumbrance Update Time Stamp