SSF_AGREE_VW(SQL View) |
Index Back |
|---|---|
Agreement TableStores all Self service Sf agreements |
| SELECT ssf_agreement_nbr , common_id , sa_id_type , ssf_agreement_type , ssf_agreement_stat , ssf_date_revoked , ec_auth_method , oprid , agreement_dt , agreement_text FROM PS_SSF_AGREE_TBL |
| # | 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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 9 | AGREEMENT_DT | Date(10) | DATE | Agreement Date |
| 10 | AGREEMENT_TEXT | Long Character | CLOB | Agreement Text |