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 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
3 | Character(4) | VARCHAR2(4) NOT NULL | Aid Year | |
4 | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Type
A=Alternate R=Regular |
|
5 | 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 | Number(8,0) | INTEGER NOT NULL | Pell COA Minimum | |
7 | Number(8,0) | INTEGER NOT NULL | Pell COA Maximum | |
8 | Number(8,0) | INTEGER NOT NULL | Pell EFC Minimum | |
9 | 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 |