SSR_RS_TPCFLDVW(SQL View) |
Index Back |
|---|
| SELECT SSR_RS_TOPIC_ID ,SSR_RS_RSRCH_TOPIC ,SSR_RS_DESCRLONG ,SSR_RS_THESIS_TITL ,SSR_RS_STATUS ,SSR_RS_ACTION_DT ,SSR_RS_TPCCMNT FROM PS_SSR_RS_TOPIC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_RS_TOPIC_ID | Character(6) | VARCHAR2(6) NOT NULL | This field is a sequential code used to create unique table entries to pre-define topics to be used in research management. |
| 2 | SSR_RS_RSRCH_TOPIC | Long Character(254) | VARCHAR2(254) | Research Topic Description |
| 3 | SSR_RS_DESCRLONG | Long Character | CLOB | This field is used for the descrlong field sin research management |
| 4 | SSR_RS_THESIS_TITL | Long Character(254) | VARCHAR2(254) | Thesis Title |
| 5 | SSR_RS_STATUS | Character(12) | VARCHAR2(12) NOT NULL | Status associated within the status group code. |
| 6 | SSR_RS_ACTION_DT | Date(10) | DATE | Status Date |
| 7 | SSR_RS_TPCCMNT | Long Character(254) | VARCHAR2(254) | Comment |