ITM_CHG_TMPL_VW (SQL View)	Index Back
List of Template list ID Item Change Process - List of Template list ID

ITM_CHG_TMPL_VW

(SQL View)

List of Template list ID

Item Change Process - List of Template list ID

SELECT A.SETID ,A.TEMPLATE_LIST_ID ,A.EFFDT , S.USERID ,S.ROLENAME FROM PS_IN_ITM_CHG_HD A ,PS_ITM_TML_LST_SEC S WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_IN_ITM_CHG_HD A_ED WHERE A_ED.SETID=A.SETID AND A_ED.TEMPLATE_LIST_ID=A.TEMPLATE_LIST_ID AND A_ED.EFFDT <=%CurrentDateIn) AND S.SETID = A.SETID AND S.TEMPLATE_LIST_ID = A.TEMPLATE_LIST_ID AND IN_TM_CHANGE_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 TEMPLATE_LIST_ID Character(20) VARCHAR2(20) NOT NULL Change List ID

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

5 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	TEMPLATE_LIST_ID	Character(20)	VARCHAR2(20) NOT NULL	Change List ID
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
5	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).