EOCC_MASKREC_VW (SQL View)	Index Back
Record Field Without Subrecs Record Filed View

EOCC_MASKREC_VW

(SQL View)

Record Field Without Subrecs

Record Filed View

SELECT RECNAME ,FIELDNAME ,RECNAME_PARENT ,FIELDNUM FROM PSRECFIELDDB

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOCC_MSK_COMP_REC Character(15) VARCHAR2(15) NOT NULL Mask Component Record Name

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

3 RECNAME_PARENT Character(15) VARCHAR2(15) NOT NULL Parent Record. If this comes from a sub-record, this column has the name of the sub-record, otherwise it has the same value as RECNAME.

4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCC_MSK_COMP_REC	Character(15)	VARCHAR2(15) NOT NULL	Mask Component Record Name
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: PSDBFIELD
3	RECNAME_PARENT	Character(15)	VARCHAR2(15) NOT NULL	Parent Record. If this comes from a sub-record, this column has the name of the sub-record, otherwise it has the same value as RECNAME.
4	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number