EOPCDEFN_IDEOPCDEFN_APPKEY_IDY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
EOPCDEFN_APPKEY(SQL Table) |
Index Back |
|---|---|
Definition Application KeysPage Composer Definition Application Keys |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCDEFN_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID |
| 2 | EOPCDEFN_APPKEY_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Defn App Key ID |
| 3 | EOPCDEFN_APP_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Use for Application Search
Y/N Table Edit Default Value: N |
| 4 | EOPCDEFN_CFG_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Use for Page Composer Display
Y/N Table Edit Default Value: N |
| 5 | EOPCDEFN_CFG_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Use for Page Composer Search
Y/N Table Edit Default Value: N |
| 6 | EOPCDEFN_CONFIG | Character(1) | VARCHAR2(1) NOT NULL |
Use for Registration Defn
Y/N Table Edit Default Value: N |
| 7 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 8 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 9 | EOPCDTTM_ADDED | DateTime(26) | TIMESTAMP | Datetime Added |
| 10 | EOPCOPRID_ADDED | Character(30) | VARCHAR2(30) NOT NULL | OprID Added |
| 11 | EOPCLASTUPDDTTM | DateTime(26) | TIMESTAMP | Last Updated |
| 12 | EOPCLASTOPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |