REFUND_CHECK

(SQL Table)
Index Back

Refund Check 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: SP_BU_SF_NONVW

2 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HCR_PERSON_I

4 CHECK_NUM_SF Character(30) VARCHAR2(30) NOT NULL Check Nbr
5 THIRD_PARTY Character(30) VARCHAR2(30) NOT NULL Third Party Check Name
6 FED_RSRV_BANK_ID Character(10) VARCHAR2(10) NOT NULL Federal Reserve Bank ID
7 SSF_BNK_ACCT_NUM Character(44) VARCHAR2(44) NOT NULL Bank Account Number
8 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
C=Checking
S=Savings
9 BANK_ACCT_NAME Character(30) VARCHAR2(30) NOT NULL Bank Account Holder Name
10 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
11 TENDER_SPEC Character(1) VARCHAR2(1) NOT NULL Tender Specific

Y/N Table Edit

12 TRACER_NBR Character(30) VARCHAR2(30) NOT NULL Tracer Number
13 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
14 CHECK_DT Date(10) DATE Check date.
15 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
16 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
17 PAY_END_DT Date(10) DATE Pay Period End Date
18 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
19 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
20 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
21 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
22 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
23 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr