EOPCDEFN_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
Prompt Table: EOPC_RECNAME_VW
Prompt Table: EOPC_FIELD_VW
EOPCDEFN_AKY2VW(SQL View) |
Index Back |
|---|
| SELECT EOPCDEFN_ID , EOPCDEFN_APPKEY_ID , EOPCDEFN_APP_SRCH , EOPCDEFN_CFG_DISP , EOPCDEFN_CFG_SRCH , EOPCDEFN_CONFIG , RECNAME , FIELDNAME , EOPCDTTM_ADDED , EOPCOPRID_ADDED , EOPCLASTUPDDTTM , EOPCLASTOPRID FROM PS_EOPCDEFN_APPKEY |
| # | 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).
Prompt Table: EOPC_RECNAME_VW |
| 8 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: EOPC_FIELD_VW |
| 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 |