SCN_SETCNTL_VW (SQL View)	Index Back
TableSet Record Detail This is a view of SET_CNTRL_REC. It's created so that a unique fieldname can be assigned to SETID. This view is used in a join for some Sales Contracts dynamic views to prevent ambiguous column name.

SCN_SETCNTL_VW

(SQL View)

TableSet Record Detail

This is a view of SET_CNTRL_REC. It's created so that a unique fieldname can be assigned to SETID. This view is used in a join for some Sales Contracts dynamic views to prevent ambiguous column name.

SELECT A.SETCNTRLVALUE ,A.REC_GROUP_ID ,A.RECNAME ,A.SETID FROM PS_SET_CNTRL_REC A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value

2 REC_GROUP_ID Character(10) VARCHAR2(10) NOT NULL Record Group ID
Prompt Table: REC_GROUP_TBL

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: REC_GROUP_REC

4 SETID_UNIQUE Character(5) VARCHAR2(5) NOT NULL SetID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
2	REC_GROUP_ID	Character(10)	VARCHAR2(10) NOT NULL	Record Group ID Prompt Table: REC_GROUP_TBL
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: REC_GROUP_REC
4	SETID_UNIQUE	Character(5)	VARCHAR2(5) NOT NULL	SetID