TL_LEFT_RF_VW (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_LEFT_RF_VW

(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 FROM PS_TL_RECFIELD_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEFT_RECNAME Character(15) VARCHAR2(15) NOT NULL Left Record (Table) Name

2 LEFT_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Left Field Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEFT_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Left Record (Table) Name
2	LEFT_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Left Field Name