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 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | ACAD_CAREER | 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 | EFFDT | 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 |