SF_GRPLINE_AET

(SQL Table)
 Index Back

Group Line Information/Check

  • Parent record: GROUP_CONT_INFO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: GROUP_CONT_VW

    3 GROUP_ID_SF Character(15) VARCHAR2(15) NOT NULL Group ID
    4 GROUP_LINE_NBR Number(6,0) INTEGER NOT NULL Group Line Number

    Default Value: 999999

    5 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type

    Prompt Table: ACCT_TYP_TBL_SF

    6 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: %EDITTABLE

    7 ITEM_EFFECTIVE_DT Date(10) DATE Item Effective Date

    Default Value: %DATE

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    10 DUE_DT Date(10) DATE Due Date
    11 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
    12 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

    Prompt Table: STDNT_CAREER

    13 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

    Prompt Table: STDNT_CAR_SEQ

    14 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: SF_TERM_VW

    15 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

    Prompt Table: STDNT_ENRL

    16 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2

    Prompt Table: SESSION_TBL

    17 FINANCE_CHARGE Character(8) VARCHAR2(8) NOT NULL Finance Charge
    18 ENCUMBRANCE_DT Date(10) DATE Encumbrance Date
    19 ENCUMBERED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Amount Encumbered
    20 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    21 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
    22 PAYMENT_PRIORITY Character(8) VARCHAR2(8) NOT NULL Payment Priority
    23 CHARGE_PRIORITY Character(8) VARCHAR2(8) NOT NULL Charge Priority List

    Prompt Table: PMT_CHRG_TBL

    24 POST_DT Date(10) DATE The Date a transaction was Posted.
    25 SSF_ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Field to hold translate values for Message Types - Error/Warning/Message
    E=Error
    M=Message
    W=Warning
    26 ENTERED_CNT Number(10,0) DECIMAL(10) NOT NULL Entered Count
    27 POST_FLAG Character(1) VARCHAR2(1) NOT NULL Line Post Flag
    D=Deleted
    N=Not Posted
    Y=Posted

    Y/N Table Edit

    Default Value: N

    28 PRIOR_POST_VAL Character(1) VARCHAR2(1) NOT NULL Prior Post Value
    29 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    30 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    31 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    32 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    33 FEE_CD Character(6) VARCHAR2(6) NOT NULL Fee Code
    34 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group
    35 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

    Prompt Table: ADM_APPL_DT_VW

    36 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr

    Prompt Table: %EDITTABLE2

    37 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Active
    C=Contingent
    D=Disputed
    H=Hold
    R=Reversed

    Default Value: A

    38 LINE_ACTION Character(3) VARCHAR2(3) NOT NULL Line Action
    APP=Application Generated
    BCK=Backing Out Term Fees
    CCP=Credit Card Payment
    CRV=Charge Reversal
    CSH=Cashiering
    GRP=Group Posting
    INT=Multi Year Interest Calc
    LAT=Late Fee Processing
    NRA=Tax Calculations
    PAY=Payment Posted
    PMT=Excess Payment
    QBK=Quick Post Back Up
    QCK=Posting Page
    REF=Refund Processing
    SSP=Self service payment
    SYS=System Generated
    TAX=Tax Adjustment Page
    TPA=Third Party - Online
    TUI=Tuition Calculation
    WRO=Writeoff Processing

    Default Value: GRP

    39 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code
    40 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    CC=Credit Card
    CHK=Check
    CSH=Cash
    DB=Debit Card
    EC=Electronic Check
    EFT=Electronic Funds Transfer
    LBX=Lockbox
    TPC=Third Party Check
    WIR=Wire Transfer
    41 CHECK_NUM_SF Character(30) VARCHAR2(30) NOT NULL Check Nbr
    42 THIRD_PARTY Character(30) VARCHAR2(30) NOT NULL Third Party Check Name
    43 CREDIT_CARD_NBR Character(44) VARCHAR2(44) NOT NULL Card Number
    44 CREDIT_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type
    AE=American Express
    DC=Diners' Club
    DI=Diners Club
    MC=MasterCard
    VI=VISA

    Prompt Table: CREDIT_CARD_TYP

    45 CREDIT_CARD_EXP_DT Date(10) DATE Expiration Date
    46 CREDIT_CARD_ISSUER Character(20) VARCHAR2(20) NOT NULL Credit Card Issuer
    47 CREDIT_CARD_HOLDER Character(30) VARCHAR2(30) NOT NULL Credit Card Holder
    48 FED_RSRV_BANK_ID Character(10) VARCHAR2(10) NOT NULL Federal Reserve Bank ID
    49 SSF_BNK_ACCT_NUM Character(44) VARCHAR2(44) NOT NULL Bank Account Number
    50 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
    C=Checking
    S=Savings
    51 BANK_ACCT_NAME Character(30) VARCHAR2(30) NOT NULL Bank Account Holder Name
    52 SF_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Reversal Indicator

    Y/N Table Edit

    Default Value: N

    53 TENDER_SPEC Character(1) VARCHAR2(1) NOT NULL Tender Specific
    54 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
    CC=Credit Card
    CCI=Credit Card In
    CCO=Credit Card Out
    CK=Check
    CKI=Check In
    CKO=Check Out
    CS=Cash
    CSI=Cash In
    CSO=Cash Out
    DB=Debit Card
    DBI=Debit Card In
    DBO=Debit Card Out
    DD=Direct Deposit
    DDI=Direct Debit
    DDO=Direct Deposit
    EC=Electronic Check
    TP=Third Party Check
    TPI=Third Party Check In
    WIR=Wire Transfer
    55 TRACER_NBR Character(30) VARCHAR2(30) NOT NULL Tracer Number
    56 OPRID_QCKPOST Character(30) VARCHAR2(30) NOT NULL Quick Post Oprid
    57 DEPOSIT_NBR Number(12,0) DECIMAL(12) NOT NULL Deposit Nbr
    58 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    59 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    60 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID
    61 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

    Prompt Table: TP_CONTRACT_VW

    62 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID
    63 ITEM_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Item Type Code
    A=Application Fee
    B=Billing Only
    C=Charge
    D=Deposit
    F=Financial Aid
    G=GL Interface Only
    H=Withholding
    I=Interest
    L=Pre-Paid Tuition
    P=Payment
    R=Refund
    T=Transfers
    V=Contributor Relations
    W=Waiver
    X=Write-off
    Z=Pay Plan Credit
    64 OVERRIDE_APPL_NBR Character(1) VARCHAR2(1) NOT NULL Override Application Number

    Y/N Table Edit

    Default Value: N

    65 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    66 ACAD_PROG2 Character(5) VARCHAR2(5) NOT NULL Academic Program
    67 ACAD_PROG3 Character(5) VARCHAR2(5) NOT NULL Academic Program 3
    68 EXTRA_REFUND_FLAG Character(1) VARCHAR2(1) NOT NULL Extra Refund Flag
    69 ORG_GROUP_ID_SF Character(15) VARCHAR2(15) NOT NULL Original Group ID
    70 ORG_GROUP_LINE_NBR Number(6,0) INTEGER NOT NULL Original Group Line Nbr
    71 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
    72 AGING_DT Date(10) DATE Aging Date
    73 AGING_FLG Character(1) VARCHAR2(1) NOT NULL Aging Flag

    Y/N Table Edit

    Default Value: N

    74 RESTRICT_ACCT_FLG Character(1) VARCHAR2(1) NOT NULL Pay Entered Acct Only

    Y/N Table Edit

    Default Value: N

    75 EXC_ACCT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Excess Account Type SF

    Prompt Table: ACCT_TYP_SF_VW

    76 EXC_ACCT_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Excess Account Type Flag

    Y/N Table Edit

    Default Value: N

    77 CHARGE_SET_TABLE Character(1) VARCHAR2(1) NOT NULL Charge Set Table Flag

    Default Value: N

    78 EMPLID_SET_TABLE Character(1) VARCHAR2(1) NOT NULL Emplid Set Table

    Default Value: N

    79 CONTRACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contract ID

    Prompt Table: PEOPLE_SRCH_SF

    80 WRITEOFF_BY Character(2) VARCHAR2(2) NOT NULL Writeoff By
    01=Entire Balance
    02=Account Number
    03=By Item Type
    04=Account Type
    81 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd

    Prompt Table: SRVC_IND_CD_TBL

    82 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List
    83 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    84 BILLING_DT Date(10) DATE Billing Date
    85 ACTUAL_BILLING_DT Date(10) DATE Actual Billing Date
    86 BILLING_FLAG Character(1) VARCHAR2(1) NOT NULL Billing Flag

    Y/N Table Edit

    Default Value: N

    87 WAIVER_CODE Character(6) VARCHAR2(6) NOT NULL Waiver Code
    88 PRIORITY Number(3,0) SMALLINT NOT NULL Priority
    89 PRIORITY_PMT_FLG Character(1) VARCHAR2(1) NOT NULL Payment Priority Flag
    90 TRANS_FEE_CD Character(8) VARCHAR2(8) NOT NULL Transaction Fee Code
    91 BILLING_CAREER Character(4) VARCHAR2(4) NOT NULL Billing Career
    92 LATE_FEE_CODE Character(6) VARCHAR2(6) NOT NULL Late Fee Code
    93 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    94 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    95 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    96 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    97 ORIGNL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    98 ORIGNL_ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
    99 CREATE_ITEM Character(1) VARCHAR2(1) NOT NULL Create Item

    Y/N Table Edit

    Default Value: N

    100 ITEM_NBR_SOURCE Character(15) VARCHAR2(15) NOT NULL Item Nbr - Src Charge Nbr
    101 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
    102 GL_FROM_SUBFEE Character(1) VARCHAR2(1) NOT NULL GL from Sub Fees
    103 CLASS_PRICE_DTTM DateTime(26) TIMESTAMP Class Price Date Time
    104 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: AID_YEAR_TBL

    105 DISBURSEMENT_DATE Date(10) DATE Disbursement Date
    106 ORIG_EFF_DT Date(10) DATE Original Effective Date
    107 SF_DEPOSIT_ID Character(10) VARCHAR2(10) NOT NULL Deposit ID
    108 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr
    109 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
    110 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
    111 SSF_INSTMNT_ID Number(3,0) SMALLINT NOT NULL Installment ID
    112 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    113 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
    114 SSF_RESTRICT_INV Character(1) VARCHAR2(1) NOT NULL This field indicates that the payment will be held until an invoice is provided.

    Default Value: N

    115 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    116 LAST_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Last Group ID
    117 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    118 REC_GROUP_ID Character(10) VARCHAR2(10) NOT NULL Record Group ID
    119 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Group Type

    Prompt Table: GROUP_TYPE_TBL

    120 ORIGIN_ID Character(5) VARCHAR2(5) NOT NULL Origin ID
    121 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    122 ENTERED_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Entered Total
    123 MOVE_INIT_FA Character(1) VARCHAR2(1) NOT NULL Move Init Financial Aid
    124 DEF_FA_ACCT_TYPE Character(3) VARCHAR2(3) NOT NULL Default Financial Aid Account
    125 MOVE_INIT_PMT Character(1) VARCHAR2(1) NOT NULL Move Init Payment
    126 MOVE_INIT_WAIVER Character(1) VARCHAR2(1) NOT NULL Move Init Waiver
    127 ACCT_TYPE_WAIVER Character(3) VARCHAR2(3) NOT NULL Excess Waiver Acct Type
    128 POST_STATUS Character(1) VARCHAR2(1) NOT NULL Posting Status
    B=Balance
    C=Complete
    E=Errors
    I=Incomplete
    N=Not Posted
    R=Reversed
    129 POST_ACTION Character(1) VARCHAR2(1) NOT NULL Posting Action
    A=Available for Posting
    D=Do Not Post
    N=Posted
    W=Waiting for Approval
    130 BALANCE_GRP Character(1) VARCHAR2(1) NOT NULL Balance the Group

    Y/N Table Edit

    Default Value: N

    131 CONTROL_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Control Total
    132 CONTROL_CNT Number(10,0) DECIMAL(10) NOT NULL Control Count
    133 CONTROL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Control Currency
    134 DIFFERENCE_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Difference Amount
    135 DIFFERENCE_CNT Signed Number(11,0) DECIMAL(10) NOT NULL Difference Count
    136 TYPE_OF_GROUP Character(1) VARCHAR2(1) NOT NULL Type of Group
    E=Student Group
    X=External Org Group

    Default Value: E