HP_RDST_TRIGVW2 (SQL View)	Index Back
EDittable prompt Bugdet change view of setid, dept and fiscal year for budget changes

HP_RDST_TRIGVW2

(SQL View)

EDittable prompt Bugdet change

view of setid, dept and fiscal year for budget changes

SELECT SETID , DEPTID , FISCAL_YEAR FROM PS_HP_RDIST_TRIGGR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

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

3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
2	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year