EODP_CTGRY_CDEODP_CLFNCDPrompt Table: EODP_CLSFCN
A=All
N=No
Y=Yes
Y/N Table Edit
Default Value: N
A=All
N=No
Y=Yes
Y/N Table Edit
Default Value: N
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
A=All
N=No
Y=Yes
Default Value: N
EODP_CTGRY_DTLS(SQL Table) |
Index Back |
|---|---|
Category code table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EODP_CTGRY_CD |
Character(6) | VARCHAR2(6) NOT NULL | Category Code |
| 2 | EODP_CLFNCD |
Number(3,0) | SMALLINT NOT NULL |
Classification Code
Prompt Table: EODP_CLSFCN |
| 3 | EODP_PERS_IDFR | Character(1) | VARCHAR2(1) NOT NULL |
Personal Identifier
A=All N=No Y=Yes Y/N Table Edit Default Value: N |
| 4 | EODP_SNSTV | Character(1) | VARCHAR2(1) NOT NULL |
Sensitive
A=All N=No Y=Yes Y/N Table Edit Default Value: N |
| 5 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |
| 6 | EODP_SYS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
System Data Flag
A=All N=No Y=Yes Default Value: N |