SFA_SAP_STP_HDR(SQL Table) |
Index Back |
|---|---|
SAP Setup HeaderHeader/Parent table for SAP Set Up Data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
|
| 2 | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
|
| 3 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
| 4 | SFA_SAP_PROC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
SAP Process Type
A=Aid Year T=Term Default Value: T |
| 5 | SFA_SAP_BFGD_DFLT | Character(4) | VARCHAR2(4) NOT NULL |
Before Fully Graded Date
Prompt Table: SFA_SAP_ST_TBL |
| 6 | SFA_SAP_AFGD_DFLT | Character(4) | VARCHAR2(4) NOT NULL |
After Fully Graded Date
Prompt Table: SFA_SAP_ST_TBL |
| 7 | SFA_SAP_UNDT_DFLT | Character(4) | VARCHAR2(4) NOT NULL |
Undetermined Default Status
Prompt Table: SFA_SAP_ST_TBL |
| 8 | SFA_SAP_CARP_DFLT | Character(4) | VARCHAR2(4) NOT NULL |
Career Pass Default Status
Prompt Table: SFA_SAP_ST_TBL |
| 9 | SFA_SAP_EXCF_DFLT | Character(4) | VARCHAR2(4) NOT NULL |
Exception Fail Default Status
Prompt Table: SFA_SAP_ST_TBL |
| 10 | SFA_SAP_ERNU_DFLT | Character(4) | VARCHAR2(4) NOT NULL |
Zero Earned Units Default Stat
Prompt Table: SFA_SAP_ST_TBL |
| 11 | SFA_SAP_MREMU_EXCL | Number(6,2) | DECIMAL(5,2) NOT NULL | Max Remedial Units to Exclude |
| 12 | SFA_SAP_MESLU_EXCL | Number(6,2) | DECIMAL(5,2) NOT NULL | Max ESL Units to Exclude |
| 13 | SFA_SAP_SA_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Statuses and Actions
Y/N Table Edit Default Value: N |
| 14 | SFA_SAP_AS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Academic Standing Test
Y/N Table Edit Default Value: N |
| 15 | SFA_SAP_MAU_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Max Attempted Units Test
Y/N Table Edit Default Value: N |
| 16 | SFA_SAP_TU_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Total Transfer Units
A=Use Accepted Transfer Units E=Exclude Transfer Units T=Use Total Transfer Units Default Value: A |
| 17 | SFA_SAP_MAT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Max Attempted Terms Test
Y/N Table Edit Default Value: N |
| 18 | SFA_SAP_MGPA_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Min Current GPA Test
Y/N Table Edit Default Value: N |
| 19 | SFA_SPCL_GPA_CD | Character(5) | VARCHAR2(5) NOT NULL |
CSU Baseline
01/09/2001
Kamran Wali /Cedar
Additional GPA Calc Mod
Mod # SR01007
Prompt Table: SPCGPA_TYPE_TBL |
| 20 | SFA_SAP_MGPAC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Min Cumulative GPA Test
Y/N Table Edit Default Value: N |
| 21 | SFA_SPCL_GPA_CD2 | Character(5) | VARCHAR2(5) NOT NULL |
Use Special GPA Code
Prompt Table: SPCGPA_TYPE_TBL |
| 22 | SFA_SAP_EU_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Current Earned Units Test
Y/N Table Edit Default Value: N |
| 23 | SFA_SAP_CEU_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Cumulative Earned Units
Y/N Table Edit Default Value: N |
| 24 | SFA_SAP_TU_FLAG2 | Character(1) | VARCHAR2(1) NOT NULL |
Use Total Transfer Units
A=Use Accepted Transfer Units E=Exclude Transfer Units T=Use Total Transfer Units Default Value: A |
| 25 | SFA_SAP_CE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Course Exclusions
Y/N Table Edit Default Value: N |
| 26 | SFA_SAP_AWE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Award Exclusions
Y/N Table Edit Default Value: N |
| 27 | SFA_SAP_EU_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Earned Unit Type
C=Use Completed Units P=Use Percentage Default Value: P |
| 28 | SFA_SAP_EU_TYPE2 | Character(1) | VARCHAR2(1) NOT NULL |
Earned Unit Type
C=Use Completed Units P=Use Percentage Default Value: P |
| 29 | SFA_SAP_SETUP_ATV | Character(1) | VARCHAR2(1) NOT NULL |
Used to define whether SAP set up data is active or inactive.
A=Active I=Inactive Default Value: A |
| 30 | SFA_SAP_GRE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
SAP Setup Grade Exclusions used flag.
Y/N Table Edit Default Value: N |
| 31 | SFA_SAP_2YR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
SAP Setup Grade Exclusions used flag.
Y/N Table Edit Default Value: N |
| 32 | SFA_SPCL_GPA_CD3 | Character(5) | VARCHAR2(5) NOT NULL |
Use Special GPA Code
Prompt Table: SPCGPA_TYPE_TBL |
| 33 | SFA_SAP_MACRSC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Course Credit
Y/N Table Edit Default Value: N |
| 34 | SFA_SAP_MATSTC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Test Credit
Y/N Table Edit Default Value: N |
| 35 | SFA_SAP_MAOTHC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Other Credit
Y/N Table Edit Default Value: N |
| 36 | SFA_SAP_MATGPA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Towards GPA
Y/N Table Edit Default Value: N |
| 37 | SFA_SAP_MANGPA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
No GPA
Y/N Table Edit Default Value: N |
| 38 | SFA_SAP_MATADJ_FLG | Character(1) | VARCHAR2(1) NOT NULL |
TC Units Adjust
Y/N Table Edit Default Value: N |
| 39 | SFA_SAP_CECRSC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Course Credit
Y/N Table Edit Default Value: N |
| 40 | SFA_SAP_CETSTC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Test Credit
Y/N Table Edit Default Value: N |
| 41 | SFA_SAP_CEOTHC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Other Credit
Y/N Table Edit Default Value: N |
| 42 | SFA_SAP_CETGPA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Towards GPA
Y/N Table Edit Default Value: N |
| 43 | SFA_SAP_CENGPA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
No GPA
Y/N Table Edit Default Value: N |
| 44 | SFA_SAP_CETADJ_FLG | Character(1) | VARCHAR2(1) NOT NULL |
TC Units Adjust
Y/N Table Edit Default Value: N |
| 45 | SFA_SAP_CACRSC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Course Credit
Y/N Table Edit Default Value: N |
| 46 | SFA_SAP_CATSTC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Test Credit
Y/N Table Edit Default Value: N |
| 47 | SFA_SAP_CAOTHC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Other Credit
Y/N Table Edit Default Value: N |
| 48 | SFA_SAP_CATGPA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Towards GPA
Y/N Table Edit Default Value: N |
| 49 | SFA_SAP_CANGPA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
No GPA
Y/N Table Edit Default Value: N |
| 50 | SFA_SAP_CATADJ_FLG | Character(1) | VARCHAR2(1) NOT NULL |
TC Units Adjust
Y/N Table Edit Default Value: N |