GP_WAFLD_VW (SQL View)	Index Back
selected flds in PSRECFIELDDB Global Payroll Field View used as prompt for selecting fields that can be populated via an Writable Array element. The function must not allow user to attempt assigning values to fields on the record that are key fields, hence the NOT IN().

GP_WAFLD_VW

(SQL View)

selected flds in PSRECFIELDDB

Global Payroll Field View used as prompt for selecting fields that can be populated via an Writable Array element. The function must not allow user to attempt assigning values to fields on the record that are key fields, hence the NOT IN().

SELECT RECNAME , FIELDNAME FROM PSRECFIELDDB WHERE FIELDNAME NOT IN ('CAL_ID','EMPLID','EMPL_RCD','CAL_RUN_ID','GP_PAYGROUP','ORIG_CAL_RUN_ID','RSLT_SEG_NUM')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).