INSTITUTIONPrompt Table: INST_CAR_SCTY
SAD_UC_APPCODESAD_UC_PERS_IDP=Principal Referee
S=Second Referee
Y/N Table Edit
SAD_UC_REF_VW(SQL View) |
Index Back |
|---|---|
IvReference/IvgReference ViewIvReference/IvgReference View |
| SELECT R.INSTITUTION , R.SAD_UC_APPCODE , R.SAD_UC_PERS_ID , R.SAD_UC_REFEREENAME , R.SAD_UC_EMAIL , R.SAD_UC_TIMESTAMP , R.SAD_UC_RELATION , R.SAD_UC_STATEMENT , R.SAD_UC_REFERENC_ID , R.SAD_UC_REFEREETYPE , R.SAD_UC_SAFEG_CON FROM PS_SAD_UC_REFERENC R WHERE R.SAD_UC_SYSTEM = 'APPL' AND R.SAD_UC_TIMESTAMP = ( SELECT MAX(R1.SAD_UC_TIMESTAMP) FROM PS_SAD_UC_REFERENC R1 WHERE R1.INSTITUTION = R.INSTITUTION AND R1.SAD_UC_APPCODE = R.SAD_UC_APPCODE AND R1.SAD_UC_PERS_ID = R.SAD_UC_PERS_ID AND R1.SAD_UC_REFEREETYPE = R.SAD_UC_REFEREETYPE AND R1.SAD_UC_REFERENC_ID = R.SAD_UC_REFERENC_ID AND R1.SAD_UC_SYSTEM = R.SAD_UC_SYSTEM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INST_CAR_SCTY |
| 2 | SAD_UC_APPCODE |
Character(10) | VARCHAR2(10) NOT NULL | Application Code |
| 3 | SAD_UC_PERS_ID |
Character(10) | VARCHAR2(10) NOT NULL | Personalid - Unique personal identifier |
| 4 | SAD_UC_REFEREE_NM | Character(200) | VARCHAR2(200) NOT NULL | Referee's Name |
| 5 | SAD_UC_EMAIL | Character(100) | VARCHAR2(100) NOT NULL | |
| 6 | SAD_UC_TIMESTAMP | DateTime(26) | TIMESTAMP | Timestamp |
| 7 | SAD_UC_RELATION | Long Character(1330) | VARCHAR2(1330) | Field for DFE API |
| 8 | SAD_UC_STATEMENT | Long Character(10240) | CLOB | Referee's Statement |
| 9 | SAD_UC_REFERENC_ID | Character(10) | VARCHAR2(10) NOT NULL | Reference ID |
| 10 | SAD_UC_REFEREETYPE | Character(30) | VARCHAR2(30) NOT NULL |
Referee Type
P=Principal Referee S=Second Referee |
| 11 | SAD_UC_SAFEG_CON | Character(1) | VARCHAR2(1) NOT NULL |
Safeguarding concerns
Y/N Table Edit |