FA_DTFIELD_VW (SQL View)	Index Back
Fee Analysis SQL Field View View over RECFIELD to return valid fieldname choices for Dates

FA_DTFIELD_VW

(SQL View)

Fee Analysis SQL Field View

View over RECFIELD to return valid fieldname choices for Dates

SELECT A.RECNAME, A.FIELDNAME FROM PSRECFIELD A, PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDTYPE = 4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_TBL Character(18) VARCHAR2(18) NOT NULL Represents the database table(s) that contain system source transaction data for reconciliation pu

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_TBL	Character(18)	VARCHAR2(18) NOT NULL	Represents the database table(s) that contain system source transaction data for reconciliation pu
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).