RECFIELD_SP1_VW (SQL View)	Index Back
View of Fields from psrecfield

RECFIELD_SP1_VW

(SQL View)

View of Fields from psrecfield

SELECT DISTINCT A.RECNAME , A.FIELDNAME , '1' FROM PSRECFIELDALL A WHERE A.RECNAME = 'SPF_REQ_LINE_JD' AND A.FIELDNAME IN ('SP_TRACK_RESRC', 'SPF_JOB_DESCRLONG', 'SP_TIME_REPORT_OPT','SPB_SC_TEAM')

# 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 LBL_TYPE Character(1) VARCHAR2(1) NOT NULL Label Type
1=Rec Long
2=Rec Short
3=Page
4=Custom
5=Panel

#	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	LBL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Label Type 1=Rec Long 2=Rec Short 3=Page 4=Custom 5=Panel