HP_ENCEMPSUSPVW (SQL View)	Index Back
Encumbrance Suspense View View that provides level 0 information of enucmbrance earning records that used a suspense account

HP_ENCEMPSUSPVW

(SQL View)

Encumbrance Suspense View

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

SELECT DISTINCT BUSINESS_UNIT , SETID , EMPLID , EMPL_RCD , FISCAL_YEAR FROM PS_ENCUMB_DIST_ERN A WHERE A.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 A.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

#	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