BPSPCMAS - Check Master for Employee Self Service (BPM) Database
Order | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
AMOUNT1 |
C |
9 |
0 |
Payment Amount 1 |
2 |
AMOUNT2 |
C |
9 |
0 |
Payment Amount 2 |
3 |
AMOUNT3 |
C |
9 |
0 |
Payment Amount 3 |
4 |
AMOUNT4 |
C |
9 |
0 |
Payment Amount 4 |
5 |
AMOUNT5 |
C |
9 |
0 |
Payment Amount 5 |
6 |
BANKACCT1 |
C |
30 |
0 |
Bank Account Number 1 |
7 |
BANKACCT2 |
C |
30 |
0 |
Bank Account Number 2 |
8 |
BANKACCT3 |
C |
30 |
0 |
Bank Account Number 3 |
9 |
BANKACCT4 |
C |
30 |
0 |
Bank Account Number 4 |
10 |
BANKACCT5 |
C |
30 |
0 |
Bank Account Number 5 |
11 |
BANKROUT1 |
C |
30 |
0 |
Bank Routing Number 1 |
12 |
BANKROUT2 |
C |
30 |
0 |
Bank Routing Number 2 |
13 |
BANKROUT3 |
C |
30 |
0 |
Bank Routing Number 3 |
14 |
BANKROUT4 |
C |
30 |
0 |
Bank Routing Number 4 |
15 |
BANKROUT5 |
C |
30 |
0 |
Bank Routing Number 5 |
16 |
CHADATE |
D |
8 |
0 |
Last Change Date |
17 |
CHECKDATE |
D |
8 |
0 |
Check Payment Date |
18 |
COADDR1 |
C |
32 |
0 |
Pay Agency Address 1 |
19 |
COADDR2 |
C |
32 |
0 |
Pay Agency Address 2 |
20 |
COCITY |
C |
26 |
0 |
Pay Agency City |
21 |
COMPANY |
C |
3 |
0 |
Company Code |
22 |
COPOSTALCD |
C |
10 |
0 |
Pay Agency Postal Code |
23 |
COSTATE |
C |
15 |
0 |
Pay Agency State |
24 |
CURDEDAMT |
N |
9 |
2 |
Current Deduction Amount |
25 |
CUREARNAMT |
N |
9 |
2 |
Current Earnings Amount |
26 |
EMPNO |
C |
9 |
0 |
Employee ID |
27 |
ENDDATE |
D |
8 |
0 |
Period End Date |
28 |
FIRSTNAME |
C |
20 |
0 |
Employee First Name from Check |
29 |
HEADERIDNO |
I |
4 |
0 |
Header ID Number |
30 |
HOURSWORKD |
I |
4 |
0 |
Hours Worked |
31 |
ID_COL |
I |
4 |
0 |
Identity Column |
32 |
LASTNAME |
C |
40 |
0 |
Employee Last Name from Check |
33 |
MIDDLENAME |
C |
20 |
0 |
Employee Middle Name from Check |
34 |
NAMESUFFIX |
C |
5 |
0 |
Name Suffix from Check |
35 |
NETPAY |
N |
9 |
2 |
Net Pay |
36 |
SSN |
C |
11 |
0 |
Employee Social Security Number |
37 |
STARTDATE |
D |
8 |
0 |
Period Start Date |
38 |
YTDDED |
N |
9 |
2 |
Year to Date Deductions |
39 |
YTDEARN |
N |
9 |
2 |
Year to Date Earnings |
40 |
YTDNETPAY |
N |
9 |
2 |
Year to Date Net Pay |