EOPCMAIN_IDEOPCFORMAT_IDEOPCFIELD_STL_IDEOPCFLD_STL1_VW(SQL View) |
Index Back |
|---|
| SELECT EOPCMAIN_ID , EOPCFORMAT_ID , EOPCFIELD_STL_ID , EOPCFIELD_ID , EOPCSTYLEHTML , EOPCSTYLECLASS , EOPCSTYLECLASS_LBL , 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_STL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Field Style ID |
| 4 | EOPCFIELD_ID | Character(20) | VARCHAR2(20) NOT NULL | EOPC Field ID |
| 5 | EOPCSTYLEHTML | Long Character | CLOB | EOPC Style HTML |
| 6 | EOPCSTYLECLASS | Character(40) | VARCHAR2(40) NOT NULL | EOPC Style Class Name |
| 7 | EOPCSTYLECLASS_LBL | Character(40) | VARCHAR2(40) NOT NULL | Label Style Class |
| 8 | EOPCDTTM_ADDED | DateTime(26) | TIMESTAMP | Datetime Added |
| 9 | EOPCOPRID_ADDED | Character(30) | VARCHAR2(30) NOT NULL | OprID Added |
| 10 | EOPCLASTUPDDTTM | DateTime(26) | TIMESTAMP | Last Updated |
| 11 | EOPCLASTOPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |