EODC_CI_MAP(SQL Table) |
Index Back |
|---|---|
Document/Form to CI Mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EODC_CATEGORY |
Character(1) | VARCHAR2(1) NOT NULL |
Document Category
D=Document F=Form |
| 2 | EO_DOCTYPE |
Character(15) | VARCHAR2(15) NOT NULL | Document Name |
| 3 | BCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Component Name (see PSBCDEFN). |
| 4 | EODC_LEVEL |
Character(1) | VARCHAR2(1) NOT NULL |
Level
0=Level 0 1=Level 1 2=Level 2 3=Level 3 Default Value: 0 |
| 5 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | EODC_PNGR_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Component Record Name
Prompt Table: %EDITTABLE2 |
| 7 | EODC_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component FieldName
Prompt Table: %EDITTABLE3 |
| 8 | EODC_SCROLLNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Level Main Record
Prompt Table: EODC_REC_VW |
| 9 | EODC_CI_COLLECTN |
Character(30) | VARCHAR2(30) NOT NULL |
CI Collection
Prompt Table: EODC_CICOL_VW |
| 10 | EODC_CI_PROPERTY |
Character(30) | VARCHAR2(30) NOT NULL |
CI Collection Property Name
Prompt Table: EODC_CIITM_VW |
| 11 | EODC_CISCROLLNAME |
Character(15) | VARCHAR2(15) NOT NULL | CI Level Main Record |
| 12 | EODC_CI_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | CI Record Name |
| 13 | EODC_CI_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | CI FieldName |
| 14 | PARENTRECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Parent Record Name
Prompt Table: EODC_REC3_VW |
| 15 | EODC_KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
CI Key Field
Y/N Table Edit Default Value: N |
| 16 | EODC_FLD_DEFAULT | Character(100) | VARCHAR2(100) NOT NULL | Default |
| 17 | EODC_ACTIVE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Event Status
N=Inactive Y=Active Default Value: Y |