HRS_APPDTA_FLD (SQL View)	Index Back
Applicant Data Fields Collects fields that will be used for the Duplicate Applicant Processing Solution.

HRS_APPDTA_FLD

(SQL View)

Applicant Data Fields

Collects fields that will be used for the Duplicate Applicant Processing Solution.

SELECT rf.RECNAME , rf.FIELDNAME , rf.USEEDIT FROM PSRECFIELDALL rf WHERE (rf.RECNAME = 'APPLICANT_VW' AND rf.FIELDNAME IN ('FIRST_NAME', 'LAST_NAME', 'MIDDLE_NAME', 'CITY', 'STATE', 'POSTAL', 'ADDRESS1', 'ADDRESS2', 'ADDRESS3', 'ADDRESS4' )) OR (rf.RECNAME = 'HRS_APP_EMAIL ' AND rf.FIELDNAME = 'EMAIL_ADDR')

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

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

#	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).
3	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference