SFA_PELL_EDIT(SQL Table) |
Index Back |
---|---|
Pell Comparison Results RecordContains Pell Comparison Results |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
4 | SFA_PELL_ALT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Type
A=Alternate R=Regular |
5 | SFA_PELL_FA_LOAD | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Schedule
F=Full-Time H=Half-Time L=Less than Half-Time N=No Unit Load T=Three Quarter Time |
6 | SFA_PELL_COA_MIN | Number(8,0) | INTEGER NOT NULL | Pell COA Minimum |
7 | SFA_PELL_COA_MAX | Number(8,0) | INTEGER NOT NULL | Pell COA Maximum |
8 | SFA_PELL_EFC_MIN | Number(8,0) | INTEGER NOT NULL | Pell EFC Minimum |
9 | SFA_PELL_EFC_MAX | Number(8,0) | INTEGER NOT NULL | Pell EFC Maximum |
10 | SFA_PELL_AWARD | Number(8,0) | INTEGER NOT NULL | Pell Award Value |
11 | SFA_PELL_AWARD_XML | Number(8,0) | INTEGER NOT NULL | XML Pell Award |
12 | SFA_PELL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Pell Status
A=Attached D=Deleted L=Loaded M=Mismatch U=Updated X=Does Not Exist |
13 | SFA_PELL_DELETEALL | Character(1) | VARCHAR2(1) NOT NULL | Delete All Edit Rows for Pell Schedule |
14 | SFA_PELL_UPDATEALL | Character(1) | VARCHAR2(1) NOT NULL | Update All Rows for Pell Schedule |
15 | SFA_PELL_UPDATESEL | Character(1) | VARCHAR2(1) NOT NULL | Update Selected Rows for Pell Schedule |