REFUND_HDR

(SQL Table)
 Index Back

Refund Header Record

Refund Header Record

  • Parent record: BUS_UNIT_TBL_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 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    3 REFUND_DTTM DateTime(26) TIMESTAMP Refund Date and Time
    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
    6 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
    7 REFUND_TYPE Character(1) VARCHAR2(1) NOT NULL Refund Type
    C=Combined
    F=Financial Aid
    N=Non Financial
    O=On-Line Request
    8 REFUND_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Refund Amount
    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    10 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID
    11 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    12 REFUND_EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL Refund External Org ID
    13 REFUND_STATUS Character(1) VARCHAR2(1) NOT NULL Refund Status
    A=AP Interface Created
    B=Credit Pending
    C=Confirmed
    D=Credit Declined
    E=Entered
    I=Interfaced to Payroll
    P=Posted
    R=Reversed
    S=Paysheet Created
    V=Sent to ePayment Servicer
    X=Cancelled
    14 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
    15 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr
    16 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr
    17 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    18 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL Operator ID Approval
    19 APPROVAL_DATETIME DateTime(26) TIMESTAMP Datetime Approval
    20 EXTRA_ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Extra Account Nbr
    21 EXTRA_ACCT_TERM Character(4) VARCHAR2(4) NOT NULL Extra Account Term
    22 EXTRA_ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Extra Item Term
    23 EXTRA_REFUND_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Extra Refund Amount
    24 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    25 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    26 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    27 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    28 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    29 CITY Character(30) VARCHAR2(30) NOT NULL City
    30 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    31 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    32 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    33 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    34 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    35 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    36 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    37 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    38 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    39 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    40 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    41 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    42 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    43 PAY_END_DT Date(10) DATE Pay Period End Date
    44 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    45 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    46 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    47 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    48 REFUND_METHODE Character(1) VARCHAR2(1) NOT NULL Refund Method
    A=Accounts Payable
    O=Other
    P=Payroll
    49 REF_APPR_OPR_1 Character(30) VARCHAR2(30) NOT NULL Approval OPRID 1
    50 REF_APPR_DATE_1 DateTime(26) TIMESTAMP Approval Date Time 1
    51 REF_APPR_OPR_2 Character(30) VARCHAR2(30) NOT NULL Approval OPRID 2
    52 REF_APPR_DATE_2 DateTime(26) TIMESTAMP Approval Data Time 2
    53 REF_APPR_OPR_3 Character(30) VARCHAR2(30) NOT NULL Approval OPRID 3
    54 REF_APPR_DATE_3 DateTime(26) TIMESTAMP Approval Data Time 3
    55 REF_APPR_ACTIVE_SW Character(1) VARCHAR2(1) NOT NULL Activate On-line Approvals

    Default Value: N

    56 REF_APPR_SW_1 Character(1) VARCHAR2(1) NOT NULL Approval Switch 1
    A=Refund Approved
    D=Refund Denied
    N=No Approval Required
    P=Pending Approval
    57 REF_APPR_SW_2 Character(1) VARCHAR2(1) NOT NULL Approval Switch 2
    A=Refund Approved
    D=Refund Denied
    N=No Approval Required
    P=Pending Approval
    58 REF_APPR_SW_3 Character(1) VARCHAR2(1) NOT NULL Approval Switch 3
    A=Approved
    D=Refund Denied
    N=No Approval Required
    P=Pending Approval
    59 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_SF.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    60 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    61 EXT_CHECK Character(15) VARCHAR2(15) NOT NULL External Check Number
    62 EXT_CHECK_NET Signed Number(18,2) DECIMAL(16,2) NOT NULL External Check Net
    63 BATCH_ID_CC Character(12) VARCHAR2(12) NOT NULL Batch ID used for processing refunds via the CyberSource Credit Card Interface
    64 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    65 SSF_REFUND_ERROR Character(1) VARCHAR2(1) NOT NULL Error Code
    A=Approval Required
    J=No Job Data
    66 SSF_RFND_EVT_ID Character(10) VARCHAR2(10) NOT NULL Default 3Cs Event ID for Refunding