SCC_POPUP_F_CVW (SQL View)	Index Back
Pop Update record fields This table host record fields selected thru Population Update. They will become available forBatch Population Update.

SCC_POPUP_F_CVW

(SQL View)

Pop Update record fields

This table host record fields selected thru Population Update. They will become available forBatch Population Update.

SELECT RECNAME , a.SCC_CAF_ATTR_SEQ , a.SCC_CAF_ATTRIB_NM , b.scc_caf_attr_type FROM PS_SCC_POPUP_F_CAF A , PS_SCC_CAF_ATTRIBS B WHERE A.SCC_CAF_ATTRIB_NM = B.SCC_CAF_ATTRIB_NM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

2 SCC_CAF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Attribute Sequence

3 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute
Prompt Table: POP_CAF_VW

4 SCC_CAF_ATTR_TYPE Character(2) VARCHAR2(2) NOT NULL Attribute Type

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	SCC_CAF_ATTR_SEQ	Number(4,0)	SMALLINT NOT NULL	Attribute Sequence
3	SCC_CAF_ATTRIB_NM	Character(20)	VARCHAR2(20) NOT NULL	Common Attribute Prompt Table: POP_CAF_VW
4	SCC_CAF_ATTR_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Attribute Type