EOPCGEN_KEYS(SQL Table) |
Index Back |
|---|---|
Page Composer Generated KeysPage Composer Generated Keys |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL | EOPC Source Code | |
| 2 | Character(18) | VARCHAR2(18) NOT NULL | Source Code Fieldname | |
| 3 | EOPCGEN_APPKEYFLD | Number(11,0) | DECIMAL(11) NOT NULL | App Key Field ID |
| 4 | EOPCGEN_APPSRCREC | Number(11,0) | DECIMAL(11) NOT NULL | App Source Rec ID |
| 5 | EOPCGEN_DEFN | Number(11,0) | DECIMAL(11) NOT NULL | Definition ID |
| 6 | EOPCGEN_DEFNAPPKEY | Number(11,0) | DECIMAL(11) NOT NULL | Defn App Key ID |
| 7 | EOPCGEN_FDSTYLE | Number(11,0) | DECIMAL(11) NOT NULL | Field Style ID |
| 8 | EOPCGEN_FIELD | Number(11,0) | DECIMAL(11) NOT NULL | Fields ID |
| 9 | EOPCGEN_FLDEVNT | Number(11,0) | DECIMAL(11) NOT NULL | Field Event ID |
| 10 | EOPCGEN_FORMAT | Number(11,0) | DECIMAL(11) NOT NULL | Format ID |
| 11 | EOPCGEN_IMAGE | Number(11,0) | DECIMAL(11) NOT NULL | Image ID |
| 12 | EOPCGEN_MAIN | Number(11,0) | DECIMAL(11) NOT NULL | Main Display ID |
| 13 | EOPCGEN_MAINFIELD | Number(11,0) | DECIMAL(11) NOT NULL | Main Display Field ID |
| 14 | EOPCGEN_PFX | Character(1) | VARCHAR2(1) NOT NULL | Generator Prefix |
| 15 | EOPCGEN_STYLE | Number(11,0) | DECIMAL(11) NOT NULL | Style ID |
| 16 | EOPCGEN_OWNER | Character(5) | VARCHAR2(5) NOT NULL |
EOPC Key Generator Owner
Default Value: 00000 |
| 17 | EOPCGEN_INTEXT | Character(1) | VARCHAR2(1) NOT NULL | Internal External Tag ID |
| 18 | EOPCNEW_DEFN | Character(1) | VARCHAR2(1) NOT NULL |
Allow New Definitions
Y/N Table Edit Default Value: N |