HP_BUDACTAMT_VW

(SQL View)
 Index Back

Budget Actuals view

BUDGET_ACTUALS view - amounts

SELECT SETID , DEPTID , FISCAL_YEAR , %Substring(ENCUMB_PROC_TYPE,1,1) , EMPLID , EMPL_RCD , HRS_JOB_OPENING_ID , HP_BUDGET_YEAR , HP_KK_DOC_ID , HP_KK_DOC_LINE_NBR , POSITION_NBR , %Substring(ENCUMB_PROC_TYPE,2,1) , POSITION_POOL_ID , SETID_JOBCODE , JOBCODE , COMPANY , PAYGROUP , BUSINESS_UNIT_GL , ACCT_CD , ACCOUNT , POSTED_ACTUAL_AMT , POSTED_NE_ACT_AMT , POSTED_ENCUMB_AMT , ANNUAL_ENCUMB_AMT , WORK_ACTUAL_AMT , WORK_ENCUMB_AMT , HP_ENC_DATE FROM PS_BUDGET_ACTUALS

  • Parent record: HP_BUDACT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

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

    Prompt Table: DEPT_TBL

    3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    4 HP_ENCUMB_PROC Character(1) VARCHAR2(1) NOT NULL Indicate the encumbrance process on Budget Actuals
    E=Encumbrance
    P=Pre-encumbrance
    R=Requisition
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: PER_ORG_ASGN_VW

    7 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JOB_OPENING

    8 HP_BUDGET_YEAR Number(4,0) SMALLINT NOT NULL Budget Year for Commitment Control
    9 HP_KK_DOC_ID Number(31,0) DECIMAL(31) NOT NULL Commitment Control Document ID
    10 HP_KK_DOC_LINE_NBR Number(3,0) SMALLINT NOT NULL Commitment Control Document Line #
    11 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    12 HP_ENCUMB_TYPE Character(1) VARCHAR2(1) NOT NULL Indicate the encumbrance type on Budget Actuals
    D=Deduction
    E=Earning
    T=Tax
    13 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID

    Prompt Table: POOL_TBL

    14 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

    Prompt Table: SET_JOB_DEP_VW

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

    Prompt Table: JOBCODE_TBL

    16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    17 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    18 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit
    19 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: ACCT_CD_CA_VW

    20 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL

    21 POSTED_ACTUAL_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Posted Actual Amount
    22 POSTED_NE_ACT_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Posted not Encumbered Actual Amount
    23 POSTED_ENCUMB_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Posted Encumbrance Amount
    24 ANNUAL_ENCUMB_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Annual Encumbered Amount
    25 WORK_ACTUAL_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Work Actual Amount
    26 WORK_ENCUMB_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Work Encumbrance Amount
    27 HP_ENC_DATE Date(10) DATE Encumbrance Date