TL_RECFIELD_VW2 (SQL View)	Index Back
Fields From All TL Work Tbls This table holds all fields for every table in TL_WORK_TABLES. This table is populated by SQR TLRECFLD, and must be refreshed when any tables in TL_WORK_TABLES are modified. the reason this is not dynamic is because the SQR will "flow" through 5 levels of subrecords to resolve subrecord/field relationships.

TL_RECFIELD_VW2

(SQL View)

Fields From All TL Work Tbls

This table holds all fields for every table in TL_WORK_TABLES. This table is populated by SQR TLRECFLD, and must be refreshed when any tables in TL_WORK_TABLES are modified. the reason this is not dynamic is because the SQR will "flow" through 5 levels of subrecords to resolve subrecord/field relationships.

SELECT RECNAME , FIELDNAME , USEEDIT , FIELDNUM FROM PS_TL_RECFIELD_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SRC_RECNAME Character(15) VARCHAR2(15) NOT NULL Source Record (Table) Name

2 SRC_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Source Field

3 USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference

4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SRC_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Source Record (Table) Name
2	SRC_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Source Field
3	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference
4	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number