SSF_1098_AGR_VW(SQL View) |
Index Back |
|---|---|
1098-T Agreement ViewThis view helps determine the existence of a 1098-T consent for a specified student. It is used on the SSF_SS_1098_SEL page to decide whether to show the consent button. |
| SELECT A.SSF_AGREEMENT_NBR ,A.COMMON_ID ,A.SA_ID_TYPE ,A.SSF_AGREEMENT_TYPE ,A.SSF_AGREEMENT_STAT ,A.SSF_DATE_REVOKED ,A.EC_AUTH_METHOD ,A.EC_AUTH_KEY ,A.OPRID ,A.AGREEMENT_DT ,A.AGREEMENT_TEXT FROM PS_SSF_AGREE_TBL A WHERE A.SA_ID_TYPE = 'P' AND A.SSF_AGREEMENT_TYPE = '02' AND A.SSF_AGREEMENT_NBR = ( SELECT MAX(A1.SSF_AGREEMENT_NBR) FROM PS_SSF_AGREE_TBL A1 WHERE A1.COMMON_ID = A.COMMON_ID AND A1.SA_ID_TYPE = A.SA_ID_TYPE AND A1.SSF_AGREEMENT_TYPE = '02') AND A.SSF_AGREEMENT_STAT = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SSF_AGREEMENT_NBR |
Character(12) | VARCHAR2(12) NOT NULL |
Agreement Number
Default Value: 0 |
| 2 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 4 | SSF_AGREEMENT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Agreement Type
01=Payment Plan Enrollment 02=1098-T Consent 03=Student Permission 04=Electronic Check 05=Bank Account 06=DD Enroll 07=DD Change |
| 5 | SSF_AGREEMENT_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Agreement Status
1=Accepted 2=Revoked Default Value: 1 |
| 6 | SSF_DATE_REVOKED | Date(10) | DATE | Date Revoked |
| 7 | EC_AUTH_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Authentication Method
BDT=Birthdate NID=National ID Number NOA=No Authentication PIN=PIN |
| 8 | EC_AUTH_KEY | Character(10) | VARCHAR2(10) NOT NULL | Authentication Key |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | AGREEMENT_DT | Date(10) | DATE | Agreement Date |
| 11 | AGREEMENT_TEXT | Long Character | CLOB | Agreement Text |