SSR_RS_CONFLDVW(SQL View) |
Index Back |
|---|
| SELECT SSR_RS_BEGIN_DT ,SSR_RS_LOAD ,SSR_RS_CAN_CNSMPTN ,SSR_RS_CNSMPTN_DAY ,SSR_RS_DAYS_REMNG ,SSR_RS_SUB_DT_MIN ,SSR_RS_SUB_DT_MAX ,SSR_RS_STATUS ,SSR_RS_ACTION_DT ,COMMENTS FROM PS_SSR_RS_CONSMPTN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_RS_BEGIN_DT | Date(10) | DATE | Begin date of the current candidature. |
| 2 | SSR_RS_LOAD | Character(4) | VARCHAR2(4) NOT NULL | Consumption load value. |
| 3 | SSR_RS_CAN_CNSMPTN | Character(1) | VARCHAR2(1) NOT NULL |
Research Enrollment Tracking candidate days or term trigger to be used in the calculation of consumption.
D=Days N=None |
| 4 | SSR_RS_CNSMPTN_DAY | Number(8,2) | DECIMAL(7,2) NOT NULL | Total Days |
| 5 | SSR_RS_DAYS_REMNG | Number(8,2) | DECIMAL(7,2) NOT NULL | Days Remaining |
| 6 | SSR_RS_SUB_DT_MIN | Date(10) | DATE | This date is the earliest date for thesis submission for a research candidate. |
| 7 | SSR_RS_SUB_DT_MAX | Date(10) | DATE | This date is the latest date for thesis submission for a research candidate. |
| 8 | SSR_RS_STATUS | Character(12) | VARCHAR2(12) NOT NULL | Status associated within the status group code. |
| 9 | SSR_RS_ACTION_DT | Date(10) | DATE | Status Date |
| 10 | COMMENTS | Long Character | CLOB | Comment |