HP_ENCUMBSUSPVW

(SQL View)
 Index Back

Encumbrance suspense accounts

View of earnings that have suspnese accounts

SELECT A.SETID , A.DEPTID , A.FISCAL_YEAR , %Substring(A.ENCUMB_PROC_TYPE,1,1) , A.EMPLID , A.EMPL_RCD , A.HRS_JOB_OPENING_ID , A.HP_KK_DOC_ID , A.HP_KK_DOC_LINE_NBR , A.POSITION_NBR , A.POSITION_POOL_ID , A.SETID_JOBCODE , A.JOBCODE , A.HP_BUDGET_YEAR , %Substring(A.ENCUMB_PROC_TYPE,2,1) , A.COMPANY , A.PAYGROUP , A.BUSINESS_UNIT_GL , A.ACCT_CD , A.ACCOUNT , A.ENCUMBERED_AMT FROM PS_ENCUMB_DIST A WHERE A.ENCUMB_PROC_TYPE IN ('EE', 'PE', 'RE') AND A.ENCUMB_POSTED = 'N' AND A.ENCUMBERED_AMT <> 0 AND A.FISCAL_YEAR = A.HP_BUDGET_YEAR AND A.ACCT_CD IN ( SELECT B.HP_ACCT_CD_SUSPNS FROM PS_DEPTBDGT_SUSPNS B WHERE B.SETID = A.SETID AND B.DEPTID = A.DEPTID AND B.FISCAL_YEAR = A.FISCAL_YEAR)

  • Parent record: HP_ENCEMPSUSPVW

    • # 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_KK_DOC_ID Number(31,0) DECIMAL(31) NOT NULL Commitment Control Document ID
    9 HP_KK_DOC_LINE_NBR Number(3,0) SMALLINT NOT NULL Commitment Control Document Line #
    10 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    11 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID

    Prompt Table: POOL_TBL

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

    Prompt Table: SET_JOB_DEP_VW

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

    Prompt Table: JOBCODE_TBL

    14 HP_BUDGET_YEAR Number(4,0) SMALLINT NOT NULL Budget Year for Commitment Control
    15 HP_ENCUMB_TYPE Character(1) VARCHAR2(1) NOT NULL Indicate the encumbrance type on Budget Actuals
    D=Deduction
    E=Earning
    T=Tax
    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 ENCUMBERED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Amount Encumbered