HP_ENCUMBSUSPVW

(SQL View)
 Index Back

Encumbrance suspense accounts

View of earnings that have suspnese accounts

SELECT A.BUSINESS_UNIT , A.SETID , A.EMPLID , A.EMPL_RCD , A.FISCAL_YEAR , A.DEPTID , A.POSITION_POOL_ID , A.SETID_JOBCODE , A.JOBCODE , A.POSITION_NBR , A.ACCT_CD , A.ENCUMB_TYPE , A.ENCUMB_ERN_AMT FROM PS_ENCUMB_DIST_ERN A WHERE A.ENCUMB_TYPE IN ( SELECT H.ENCUMB_TYPE FROM PS_ENCUMB_DIST_ERN H WHERE H.ACCT_CD IN ( SELECT HP_ACCT_CD_SUSPNS FROM PS_DEPTBDGT_SUSPNS B WHERE B.DEPTID = A.DEPTID AND A.FISCAL_YEAR = B.FISCAL_YEAR) AND H.BUSINESS_UNIT = A.BUSINESS_UNIT AND H.SETID = A.SETID AND H.EMPLID = A.EMPLID AND H.EMPL_RCD = A.EMPL_RCD AND H.FISCAL_YEAR = A.FISCAL_YEAR AND H.ENCUMB_POSTED = 'N')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
7 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID
8 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
9 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
10 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
11 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: HP_ENCSUSP_ACCT

12 ENCUMB_TYPE Character(1) VARCHAR2(1) NOT NULL Encumbrance Type
E=Encumbered
R=Reversal
13 ENCUMB_ERN_AMT Number(16,2) DECIMAL(15,2) NOT NULL Encumbrance Earnings Amount