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

FA_RECFIELD_VW

(SQL View)

Fee Analysis SQL Field View

View over RECFIELD to return valid fieldname choices

SELECT RECNAME, FIELDNAME FROM PSRECFIELD

# 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).