EODP_RECFLDDB1 (SQL View)	Index Back
All Recnames in EODP_RECFieLD Data Privacy Framework: Find all Record Names in EODP_RECFIELD including parent recnames for subrecords

EODP_RECFLDDB1

(SQL View)

All Recnames in EODP_RECFieLD

Data Privacy Framework: Find all Record Names in EODP_RECFIELD including parent recnames for subrecords

SELECT DISTINCT B.RECNAME ,B.FIELDNAME ,B.RECNAME_PARENT ,A.EODP_CTGRY_CD , A.EODP_CLFNCD ,A.EODP_PERS_IDFR ,A.EODP_SNSTV ,A.LASTUPDDTTM FROM PS_EODP_RECFIELD A ,PSRECFIELDDB B WHERE (A.RECNAME=B.RECNAME AND A.FIELDNAME=B.FIELDNAME) OR ( A.FIELDNAME=B.FIELDNAME AND A.RECNAME=B.RECNAME_PARENT AND NOT EXISTS ( SELECT 'X' FROM PS_EODP_RECFIELD X WHERE X.RECNAME=B.RECNAME AND X.FIELDNAME=B.FIELDNAME))

# 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 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 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code
Prompt Table: EODP_CTGRY_CODE

5 EODP_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code
Prompt Table: EODP_CLSFCN_VW

6 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
A=All
N=No
Y=Yes
Y/N Table Edit
Default Value: N

7 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
A=All
N=No
Y=Yes
Y/N Table Edit
Default Value: N

8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	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	EODP_CTGRY_CD	Character(6)	VARCHAR2(6) NOT NULL	Category Code Prompt Table: EODP_CTGRY_CODE
5	EODP_CLFNCD	Number(3,0)	SMALLINT NOT NULL	Classification Code Prompt Table: EODP_CLSFCN_VW
6	EODP_PERS_IDFR	Character(1)	VARCHAR2(1) NOT NULL	Personal Identifier A=All N=No Y=Yes Y/N Table Edit Default Value: N
7	EODP_SNSTV	Character(1)	VARCHAR2(1) NOT NULL	Sensitive A=All N=No Y=Yes Y/N Table Edit Default Value: N
8	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.