STDNT_FA_MSGS(SQL Table) |
Index Back |
|---|---|
Stdnt Fin Aid Edit MsgsSTDNT_FA_MSGS is a user maintained table used for storing and maintaining edit messages regarding Financial Aid processing for the student. These messages are commonly problems that users have identified with user queries, and alert the user to processing issues that need to be addressed. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: STUDENT_AID |
| 4 | EDIT_MSG_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Edit Message Type
E=Error I=Informational W=Warning |
| 5 | EDIT_MSG_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Edit Message Code
Prompt Table: FA_EDIT_MSG_TBL |
| 6 | FA_MSG_DTTIME |
DateTime(26) | TIMESTAMP NOT NULL |
FA Message Date/Time
Default Value: %date |
| 7 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_VAL_TBL |
| 8 | FA_MSG_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Edit Message Action
1=No Action Taken 2=Resolved 3=Action Pending Default Value: 1 |
| 9 | EDIT_PROCESS | Character(8) | VARCHAR2(8) NOT NULL | User Edit Process |
| 10 | COMPLETED_DT | Date(10) | DATE |
Date Activity Completed
Default Value: %date |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 12 | COMMENTS | Long Character | CLOB | Comment |