HP_ENCEMPSUSPVW

(SQL View)
Index Back

Encumbrance Suspense View

View that provides level 0 information of enucmbrance earning records that used a suspense account

SELECT DISTINCT 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 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 Of HP_ENCUMBSUSPVW
  • # 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