ITEM_LINE_SF

(SQL Table)
 Index Back

  • Related Language Record: ITEM_LNE_SF_LNG

  • Parent record: ITEM_SF

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

    Prompt Table: SP_BU_SF_NONVW

    2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    4 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr

    Prompt Table: ITEM_SF

    5 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    7 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr

    Prompt Table: ACCOUNT_SF

    8 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term

    Prompt Table: TERM_VAL_TBL

    9 POSTED_DATE Date(10) DATE Date Posted
    10 ITEM_EFFECTIVE_DT Date(10) DATE Item Effective Date
    11 GL_POSTING_DTTM DateTime(26) TIMESTAMP GL Posting Date Time
    12 BILLING_DT Date(10) DATE Billing Date
    13 DUE_DT Date(10) DATE Due Date
    14 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
    15 LINE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Line Amount
    16 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount
    17 DISPUTE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Dispute Amount
    18 DISPUTE_DT Date(10) DATE Dispute Date
    19 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
    20 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    21 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
    22 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
    23 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    24 FINANCE_CHARGE Character(8) VARCHAR2(8) NOT NULL Finance Charge
    25 ENCUMBRANCE_DT Date(10) DATE Encumbrance Date
    26 ENCUMBERED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Amount Encumbered
    27 FEE_CD Character(6) VARCHAR2(6) NOT NULL Fee Code
    28 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group
    29 POSTED_DATETIME DateTime(26) TIMESTAMP Posted Date & Time
    30 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    31 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Active
    C=Contingent
    D=Disputed
    H=Hold
    R=Reversed
    32 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
    33 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code

    Prompt Table: LINE_REASON_TBL

    34 AGING_DT Date(10) DATE Aging Date
    35 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
    36 AGING_FLG Character(1) VARCHAR2(1) NOT NULL Aging Flag

    Y/N Table Edit

    Default Value: N

    37 DUE_DATE_BY Character(3) VARCHAR2(3) NOT NULL Due Date Enter By
    GNR=Generated by Billing
    GRP=Group Post Program
    QCK=Quick Post Program
    TUI=Tuition Calc Program
    38 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    39 ORIGINAL_ACCT_TERM Character(4) VARCHAR2(4) NOT NULL Original Account Term
    40 AGING2_FLAG Character(1) VARCHAR2(1) NOT NULL Aging Flag

    Y/N Table Edit

    41 DEPOSIT_NBR Number(12,0) DECIMAL(12) NOT NULL Deposit Nbr
    42 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    43 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    44 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID

    Prompt Table: PEOPLE_SRCH

    45 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    46 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID
    47 ORG_GROUP_ID_SF Character(15) VARCHAR2(15) NOT NULL Original Group ID
    48 ORG_GROUP_LINE_NBR Number(6,0) INTEGER NOT NULL Original Group Line Nbr
    49 GRP_TIMESTAMP DateTime(26) TIMESTAMP Group Line Time Stamp
    50 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
    51 ACTUAL_BILLING_DT Date(10) DATE Actual Billing Date
    52 BILLING_FLAG Character(1) VARCHAR2(1) NOT NULL Billing Flag

    Y/N Table Edit

    Default Value: N

    53 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    54 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    55 PAY_END_DT Date(10) DATE Pay Period End Date
    56 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
    57 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    58 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    59 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
    60 SENT_HRNRA_FLAG Character(1) VARCHAR2(1) NOT NULL Sent/Calculated for HR NRA

    Y/N Table Edit

    Default Value: N

    61 AGING_LATE_FEES_DT Date(10) DATE Late Fees Last Aging Aging Dt
    62 LINE_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Line Reversal Indicator

    Y/N Table Edit

    Default Value: N

    63 T4_SENT_FLG Character(1) VARCHAR2(1) NOT NULL T4 Sent Flag

    Y/N Table Edit

    Default Value: N

    64 CLASS_PRICE_DTTM DateTime(26) TIMESTAMP Class Price Date Time
    65 TRACER_NBR Character(30) VARCHAR2(30) NOT NULL Tracer Number
    66 ORIG_DUE_DATE Date(10) DATE Original Due Date
    67 SSF_ITEM_NBR_STCHG Character(15) VARCHAR2(15) NOT NULL Contract Emplid Charge
    68 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    69 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    70 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    71 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time