EOPCMAIN_IDEOPCFORMAT_IDEOPCFIELD_IDEOPCFIELDSTYLE_IDEOPCFLD_STL2_VW(SQL View) |
Index Back |
|---|
| SELECT EOPCMAIN_ID , EOPCFORMAT_ID , EOPCFIELD_ID , EOPCFIELD_STL_ID , EOPCSTYLEHTML , EOPCDTTM_ADDED , EOPCOPRID_ADDED , EOPCLASTUPDDTTM , EOPCLASTOPRID FROM PS_EOPCFIELD_STYLE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCMAIN_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Section ID |
| 2 | EOPCFORMAT_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Format ID |
| 3 | EOPCFIELD_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Field ID |
| 4 | EOPCFIELDSTYLE_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Field Style ID |
| 5 | EOPCSTYLEHTML | Long Character | CLOB | EOPC Style HTML |
| 6 | EOPCDTTM_ADDED | DateTime(26) | TIMESTAMP | Datetime Added |
| 7 | EOPCOPRID_ADDED | Character(30) | VARCHAR2(30) NOT NULL | OprID Added |
| 8 | EOPCLASTUPDDTTM | DateTime(26) | TIMESTAMP | Last Updated |
| 9 | EOPCLASTOPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |