| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 5 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 6 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 7 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
|
| 8 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 9 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 10 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 11 |
NSLDS_AGGR_PERKINS |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Aggregate Perkins
|
| 12 |
NSLDS_AGGR_SUBSDZD |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Aggregate Subsidized
|
| 13 |
NSLDS_AGGR_UNSUB |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Aggregate Unsubsidized
|
| 14 |
NSLDS_PELL_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Pell Overpayment
D=Deferred
F=Fraud
N=No
S=Satisfactory Arrangement
W=Waived
Y=Yes
|
| 15 |
NSLDS_PELL_PD2DT |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Pell Paid to Date
|
| 16 |
NSLDS_SEOG_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS SEOG Overpayment
D=Deferred
F=Fraud
N=No
S=Satisfactory Arrangement
W=Waived
Y=Yes
|
| 17 |
RECORD_COUNT |
Number(7,0) |
INTEGER NOT NULL |
Count of Records
|
| 18 |
RETURN_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Return code
0=0. Successful Load on E1
1=1. Account Number Mismatch
2=2. Inserting Error
|
| 19 |
SFA_NSLDS_AGGR_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
FA-Aggregate: NSLDS Total
|
| 20 |
SFA_NSLDS_AGGR_TYP |
Character(4) |
VARCHAR2(4) NOT NULL |
FA-Aggregates, NSLDS Program Type
ACG=Academic Competitiveness Grant
GPLS=Graduate PLUS
NSG=National SMART Grant
PELL=Pell
PERK=Perkins
SEOG=SEOG
SUB=Subsidized
TCH=TEACH Grant
USUB=Unsubsidized
|
| 21 |
SFA_NSLDS_PUSH_DT |
Date(10) |
DATE |
FA-Aggregates: Date NSLDS Data was pushed.
|
| 22 |
SFA_NSLDS_PUSH_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
FA-Aggregates: NSLDS Data Push Option (Refresh vs. Update)
R=Refresh NSLDS Data
U=Update NSLDS Data
|
| 23 |
SFA_OVERRIDE_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
FA-Aggregates: Preserver Override during NSLDS Data Push
|
| 24 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 25 |
CPS_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
CPS School Code. Also known as Title IV School Code
|
| 26 |
QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
|
| 27 |
SFA_AGGR_RUNOPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
FA-Aggregates Run Control Option
B=Both FAH and TM
H=Financial Aid History only
T=Transfer Monitoring only
|
| 28 |
SFA_LAST_NSLDS_SEQ |
Character(2) |
VARCHAR2(2) NOT NULL |
Last Seuqence Number used
|
| 29 |
SFA_NSLDS_ENROL_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Transfer Monitoring Request enrollment start date.
|
| 30 |
SFA_NSLDS_IDSELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Population Selection
A=All students
L=Students in list
O=One student
Q=Use Query
|
| 31 |
SFA_NSLDS_SEQ_NBR |
Number(2,0) |
SMALLINT NOT NULL |
NSLDS Request File sequence number (up to 99 per given submittal date).
|
| 32 |
SFA_SUBMITTAL_DT |
Date(10) |
DATE |
NSLDS Request file submittal date.
|
| 33 |
SFA_TM_BEGIN_CHRDT |
Character(8) |
VARCHAR2(8) NOT NULL |
Transfer Monitoring begin date - character representation.
|
| 34 |
SFA_TM_BEGIN_DT |
Date(10) |
DATE |
FA-Aggregates: Transfer Monitoring Begin Date
|
| 35 |
TERM_BEGIN_DT |
Date(10) |
DATE |
Term Begin Date
|
| 36 |
SFA_AGGR_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
FA-Aggregate Source for Packaging
D=FA Installation Default
N=NSLDS Total
P=PS Aggregates
|
| 37 |
SFA_PROC_RUN_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate process execution mode (Batch vs. Remote Call). Created for the FA External Award Load process.
B=Batch Process
R=On-line Process
Default Value: R
|
| 38 |
SFA_ACG_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
ACG Overpayment
D=Deferred
F=Fraud
N=N/A
N=N/A
S=Satisfactory Arrangement
W=Waived
Y=Overpayment
|
| 39 |
SFA_ACG_PD2DT |
Number(6,0) |
INTEGER NOT NULL |
ACG Paid to Date
|
| 40 |
SFA_NSG_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS NSG Overpayment
D=Deferred
F=Fraud
N=N/A
S=Satisfactory Arrangement
W=Waived
Y=Overpayment
|
| 41 |
SFA_NSG_PD2DT |
Number(6,0) |
INTEGER NOT NULL |
NSG Paid to Date
|
| 42 |
GRAD_LIMIT_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduate Limit Rule
C=Cumulative
D=Distinct
Default Value: D
|
| 43 |
UNDRGRAD_TOTAL |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Total Undergrad
|
| 44 |
GRADUATE_TOTAL |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Total Graduate
|
| 45 |
TOTAL_TERMS |
Number(2,0) |
SMALLINT NOT NULL |
Total Terms
|
| 46 |
AGGREGATE_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
Aggregate Area
Prompt Table:
AGGR_LIMIT_VW
|
| 47 |
ACTUAL_AWARD |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Actual Award
|
| 48 |
NSLDS_PERK_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Perkins Overpayment
D=Deferred
F=Fraud
N=No
S=Satisfactory Arrangement
W=Waived
Y=Yes
|
| 49 |
AGGREGATE_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Aggregate Level
|
| 50 |
SFA_ACG_SCHL_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
ACG School Code
|
| 51 |
SFA_NSG_SCHL_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
NSG School Code
|
| 52 |
ORIG_AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Original Aid Year
|
| 53 |
SFA_ASG_ACAD_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Academic Level
0=1st Year - Never Attended
1=1st Year - Previously Attended
2=2nd Year
3=3rd Year
4=4th Year
5=5th Year
6=Grad/Professional - 1st Year
7=Grad/Professional - Continuing
|
| 54 |
NSLDS_REC_CNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
NSLDS Record Count
|
| 55 |
SFA_TCH_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Overpayment
D=Deferred
F=Fraud
N=N/A
S=Satisfactory Payment
W=Waived
Y=Overpayment
|
| 56 |
SFA_TCH_PD2DT |
Number(6,0) |
INTEGER NOT NULL |
Teach Paid to Date
|
| 57 |
SFA_TCH_SCHL_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
TEACH School Code
|
| 58 |
SFA_TCH_SCHL_YR |
Character(1) |
VARCHAR2(1) NOT NULL |
Teach Academic Level
|
| 59 |
SFA_NSLDS_GRAD_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
FA-Aggregate: NSLDS Graduate Total
|
| 60 |
SFA_PRCNT_USED_RPT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Reported Percent Scheduled Used
|
| 61 |
SFA_PRCNT_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent Scheduled Used Override flag.
|
| 62 |
SFA_AGGR_GPLUS |
Number(6,0) |
INTEGER NOT NULL |
Grad PLUS Outstanding Balance
|
| 63 |
SFA_PRCNT_USED_TOT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Total Percent Scheduled Used
|
| 64 |
SFA_BRANCH_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Branch Code
|
| 65 |
SCCPS_TOOL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Tool ID - the unique key for a pop select tool
|
| 66 |
SCCPS_QUERY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Query / Section name used by population selection
|
| 67 |
SCCPS_CNTXT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Context ID - the unique key that identifies the pop selection context
|
| 68 |
SCCPS_RSLTS_TABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Results table for population selection. This is the table that is populated with the results of the selection. This table is set on the Context.
|
| 69 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 70 |
SCCPS_FILE_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Pop Select File Path and Name
|
| 71 |
SCCPS_POP_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.
|
| 72 |
STDNT_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Override
Y/N Table Edit
|
| 73 |
OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Method
|
| 74 |
SFA_LEU_NSLDS |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
Lifetime Eligibility Used
|
| 75 |
SFA_LEU_NSLDS_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent Scheduled Used Override flag.
Y/N Table Edit
|