TMP_TBL_ASGN_VW

(SQL View)

select a.temp_tbl_name, a.temp_tbl_num, a.in_use_sw, a.process_instance from PS_TEMP_TBL_ASGNM a where a.temp_tbl_num = (select max(b.temp_tbl_num) from PS_TEMP_TBL_ASGNM b where b.temp_tbl_name = a.temp_tbl_name)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEMP_TBL_NAME Character(12) VARCHAR2(12) NOT NULL Temporary Table name

2 TEMP_TBL_NUM Character(3) VARCHAR2(3) NOT NULL Temporary Table Number

3 IN_USE_SW Character(1) VARCHAR2(1) NOT NULL Table in use switch
Default Value: N

4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
Default Value: 0

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEMP_TBL_NAME	Character(12)	VARCHAR2(12) NOT NULL	Temporary Table name
2	TEMP_TBL_NUM	Character(3)	VARCHAR2(3) NOT NULL	Temporary Table Number
3	IN_USE_SW	Character(1)	VARCHAR2(1) NOT NULL	Table in use switch Default Value: N
4	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance Default Value: 0