EODP_RECFLD_DAT

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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.

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

4 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
A=All
N=No
Y=Yes

5 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
A=All
N=No
Y=Yes

6 EODP_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.

7 EODP_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	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.
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	EODP_PERS_IDFR	Character(1)	VARCHAR2(1) NOT NULL	Personal Identifier A=All N=No Y=Yes
5	EODP_SNSTV	Character(1)	VARCHAR2(1) NOT NULL	Sensitive A=All N=No Y=Yes
6	EODP_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.
7	EODP_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.