EODP_COMP_STG (SQL Table)	Index Back
View References Page record View Refernces Main Record used in Data Privacy Component

EODP_COMP_STG

(SQL Table)

View References Page record

View Refernces Main Record used in Data Privacy Component

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

2 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

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

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

5 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

6 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text

7 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code
Prompt Table: EODP_CTGRY_CODE

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

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

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

11 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

12 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	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
2	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
6	LBLTEXT	Character(60)	VARCHAR2(60) NOT NULL	Label Text
7	EODP_CTGRY_CD	Character(6)	VARCHAR2(6) NOT NULL	Category Code Prompt Table: EODP_CTGRY_CODE
8	EODP_CLFNCD	Number(3,0)	SMALLINT NOT NULL	Classification Code Prompt Table: EODP_CLSFCN_VW
9	EODP_PERS_IDFR	Character(1)	VARCHAR2(1) NOT NULL	Personal Identifier A=All N=No Y=Yes Y/N Table Edit Default Value: N
10	EODP_SNSTV	Character(1)	VARCHAR2(1) NOT NULL	Sensitive A=All N=No Y=Yes Y/N Table Edit Default Value: N
11	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12	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.