SCC_SFP_G_LN_VW

(SQL View)
Index Back

Group Line Information/Check


SELECT A.BUSINESS_UNIT , A.GROUP_ID_SF , GROUP_LINE_NBR ,A.POST_STATUS , ACCOUNT_TYPE_SF , ITEM_TYPE , ITEM_EFFECTIVE_DT , DESCR , EMPLID , DUE_DT , REF1_DESCR , ACAD_CAREER , STDNT_CAR_NBR , STRM , CLASS_NBR , SESSION_CODE , FINANCE_CHARGE , ENCUMBRANCE_DT , ENCUMBERED_AMT , ACAD_YEAR , ITEM_AMT , PAYMENT_PRIORITY , CHARGE_PRIORITY , B.POST_DT , SSF_ERROR_WARN , POST_FLAG , PRIOR_POST_VAL , ACCOUNT_NBR , ACCOUNT_TERM , INSTITUTION , ITEM_NBR , FEE_CD , SEL_GROUP , ADM_APPL_NBR , PAYMENT_ID_NBR , LINE_STATUS , LINE_ACTION , LINE_REASON_CD , PAYMENT_METHOD , CHECK_NUM_SF , THIRD_PARTY , CREDIT_CARD_NBR , CREDIT_CARD_TYPE , CREDIT_CARD_EXP_DT , CREDIT_CARD_ISSUER , CREDIT_CARD_HOLDER , FED_RSRV_BANK_ID , SSF_BNK_ACCT_NUM , BANK_ACCT_TYP , BANK_ACCT_NAME , SF_REVERSAL_IND , TENDER_SPEC , TENDER_CATEGORY , TRACER_NBR , OPRID_QCKPOST , DEPOSIT_NBR , REFUND_NBR , EXT_ORG_ID , REFUND_EMPLID , CONTRACT_NUM , COLLECTION_ID , ITEM_TYPE_CD , OVERRIDE_APPL_NBR , ACAD_PROG , ACAD_PROG2 , ACAD_PROG3 , EXTRA_REFUND_FLAG , ORG_GROUP_ID_SF , ORG_GROUP_LINE_NBR , RECEIPT_NBR , AGING_DT , AGING_FLG , RESTRICT_ACCT_FLG , EXC_ACCT_TYPE_SF , EXC_ACCT_TYPE_FLG , CHARGE_SET_TABLE , EMPLID_SET_TABLE , CONTRACT_EMPLID , WRITEOFF_BY , SRVC_IND_CD , COURSE_LIST , CRSE_ID , BILLING_DT , ACTUAL_BILLING_DT , BILLING_FLAG , WAIVER_CODE , PRIORITY , PRIORITY_PMT_FLG , TRANS_FEE_CD , BILLING_CAREER , LATE_FEE_CODE , CUR_RT_TYPE , RATE_MULT , RATE_DIV , CURRENCY_CD , ORIGNL_CURRENCY_CD , ORIGNL_ITEM_AMT , CREATE_ITEM , ITEM_NBR_SOURCE , TAX_AUTHORITY_CD , GL_FROM_SUBFEE , CLASS_PRICE_DTTM , AID_YEAR , DISBURSEMENT_DATE , ORIG_EFF_DT , SF_DEPOSIT_ID , SF_PMT_REF_NBR , BANK_CD , INVOICE_ID , SSF_RESTRICT_INV , CR_CARD_DIGITS , SSF_INSTMNT_ID FROM PS_GROUP_LINE B , PS_GROUP_CONT_INFO A WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.GROUP_ID_SF = B.GROUP_ID_SF

  • Parent record: GROUP_CONT_INFO
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: GROUP_CONT_VW

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

    Default Value: 999999

    4 POST_STATUS Character(1) VARCHAR2(1) NOT NULL Posting Status
    B=Balance
    C=Complete
    E=Errors
    I=Incomplete
    N=Not Posted
    R=Reversed
    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 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

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: ADM_APPL_DT_VW

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

    Prompt Table: %EDITTABLE2

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

    Default Value: A

    37 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

    38 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code
    39 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
    40 CHECK_NUM_SF Character(30) VARCHAR2(30) NOT NULL Check Nbr
    41 THIRD_PARTY Character(30) VARCHAR2(30) NOT NULL Third Party Check Name
    42 CREDIT_CARD_NBR Character(44) VARCHAR2(44) NOT NULL Card Number
    43 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

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

    Y/N Table Edit

    Default Value: N

    52 TENDER_SPEC Character(1) VARCHAR2(1) NOT NULL Tender Specific
    53 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
    54 TRACER_NBR Character(30) VARCHAR2(30) NOT NULL Tracer Number
    55 OPRID_QCKPOST Character(30) VARCHAR2(30) NOT NULL Quick Post Oprid
    56 DEPOSIT_NBR Number(12,0) DECIMAL(12) NOT NULL Deposit Nbr
    57 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    58 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

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

    Prompt Table: TP_CONTRACT_VW

    61 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID
    62 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
    63 OVERRIDE_APPL_NBR Character(1) VARCHAR2(1) NOT NULL Override Application Number

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ACCT_TYP_SF_VW

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Prompt Table: PEOPLE_SRCH_SF

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

    Prompt Table: %EDITTABLE4

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: CURRENCY_CD_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: AID_YEAR_TBL

    104 DISBURSEMENT_DATE Date(10) DATE Disbursement Date
    105 ORIG_EFF_DT Date(10) DATE Original Effective Date
    106 SF_DEPOSIT_ID Character(10) VARCHAR2(10) NOT NULL Deposit ID
    107 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr
    108 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
    109 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number

    Prompt Table: %EDITTABLE3

    110 SSF_RESTRICT_INV Character(1) VARCHAR2(1) NOT NULL This field indicates that the payment will be held until an invoice is provided.

    Y/N Table Edit

    Default Value: N

    111 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
    112 SSF_INSTMNT_ID Number(3,0) SMALLINT NOT NULL Installment ID