SSR_RS_ASNFLDVW(SQL View) |
Index Back |
|---|
| SELECT SSR_RS_RQUIRE_TYPE ,SSR_RS_EXP_COMP_DT ,SSR_RS_APPRVL_DT ,SSR_RS_APPRVR_ID ,SSR_RS_COMMITTEE ,SSR_RS_STATUS ,SSR_RS_ACTION_DT ,COMMENTS FROM PS_SSR_RS_OTHRQDTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_RS_RQUIRE_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Field to hold Research Assignment Types |
| 2 | SSR_RS_EXP_COMP_DT | Date(10) | DATE | Completion Date |
| 3 | SSR_RS_APPRVL_DT | Date(10) | DATE | This field tracks the date that the approval is sought for ethical implications for research management tracking. |
| 4 | SSR_RS_APPRVR_ID | Character(11) | VARCHAR2(11) NOT NULL | Approver ID |
| 5 | SSR_RS_COMMITTEE | Character(6) | VARCHAR2(6) NOT NULL | Research Enrollment Tracking |
| 6 | SSR_RS_STATUS | Character(12) | VARCHAR2(12) NOT NULL | Status associated within the status group code. |
| 7 | SSR_RS_ACTION_DT | Date(10) | DATE | Status Date |
| 8 | COMMENTS | Long Character | CLOB | Comment |