SFA_SAP_STP_HDR

(SQL Table)
Index Back

SAP Setup Header

Header/Parent table for SAP Set Up Data.

  • Parent record: ACAD_CAR_TBL
  • # 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