BPSPCMAS - Check Master for Employee Self Service (BPM) Database

BPSPCMAS field information

 
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