Payment History Extract - Decentralized Format File Description

This file is a payment history extract file. It is created by selecting the DECENT. format from the payment history extract screen. Selecting this format will result in a file that mirrors the PPSD Data Management business month payment history tape. Note: Data in this file format can only be downloaded. It can not be used to generate ad hoc reports in CIRS.  

 

  • File Name: PD.CSUCFOC.RPTUSER.DECENTAP.userid

  • Record Length: 3832

  • Organization: One record per payment transaction.

 


Segment 1, Segment Occurs = 1 time, Segment Size = 484

Start
Position

Description

Length

Format

1

Social Security Number

9

X(9)

10

Pay Period, Date (YYMM)

4

9(4)

14

Pay Period, Type

1

X

15

Position Sequence Number

2

9(2)

17

Agency Code

3

X(3)

20

Reporting Unit

3

X(3)

23

Class Code

4

X(4)

27

Serial Number

3

X(3)

30

Cycle Date (YYMMDD)

6

X(6)

36

Warrant Number

8

X(8)

36

Accounts Receivable Number

5

X(5)

44

Clearance Type

1

X

45

Transaction Code, Personnel

3

X(3)

48

Key Sequence Code

2

9(2)

50

Suspense Code

1

X

51

Earnings ID #1

4

X(4)

55

Earnings ID #2

4

X(4)

59

Earnings ID #3

4

X(4)

63

Fiscal Year (CCYY)

4

9(4)

67

Special Pay

1

X

68

Record Type

1

X

69

Summarized Warrant

1

X

70

Reported Redeposit

1

X

71

Class Type

1

X

72

Budget Function Code

3

X(3)

75

Suspense Date

6

X(6)

82

Accounts Receivable Dock Time Code

1

X

83

Collective Bargaining ID

3

X(3)

86

Collective Bargaining Authority

1

X

88

Locked-In-Premium Indicator

1

X

89

Accounts Receivable Type

1

X

90

Register Warrant Indicator

1

X

91

Name, First Init

1

X

92

Name, Middle Init

1

X

93

Name, Last

21

X

114

Issue Date (CCYYMMDD)

8

X(8)

122

Original Issue Date (CCYYMMDD)

8

X(8)

130

Originating Document Transaction Code

3

X(3)

142

Payment Type

1

X

143

Payment Type, Suffix

1

X

144

Adjustment Code

1

X

145

Accounts Receivable Code

1

X

146

Roll Code

1

X

147

Range Code

2

X(2)

149

FLSA

4

X(4)

153

Salary Type

1

X

154

Salary Rate

7

S9(5)V99

161

Actual Rate

7

S9(5)V99

168

Salary Full

7

S9(5)V99

175

Gross Type

1

X

176

Time Base Numerator

3

X(3)

179

Time Base Denominator

3

X(3)

182

Shift Differential

1

X

183

Overtime Code

1

X

184

Days Paid

2

99

186

Hours Paid

5

S9(3)V99

184

Units Paid

7

S9(5)V99

191

Days Docked

2

S9(2)

193

Hours Docked

3

S9V99

196

Federal Married Status

1

X

197

Federal Tax Exemptions

2

9(2)

199

Federal Tax Gross, Employee

7

S9(5)V99

206

Federal Tax Withheld, Employee

7

S9(5)V99

217

State Married Status

1

X

218

State Tax Exemptions

2

9(2)

220

State Itemized Allowances

2

9(2)

222

State Code 1

2

X(2)

224

State Tax Gross 1

7

S9(5)V99

231

State Tax Withheld 1

7

S9(5)V99

242

State Code 2

2

X(2)

244

State Tax Gross 2

7

S9(5)V99

251

State Tax Withheld 2

7

S9(5)V99

262

Employee Social Security Tax Gross

7

S9(5)V99

269

Employee Social Security Withheld

7

S9(5)V99

276

Employer Social Security Tax Gross

7

S9(5)V99

283

Employer Social Security Withheld

7

S9(5)V99

290

Employee Medicare Tax Gross

7

S9(5)V99

297

Employee Medicare Withheld

7

S9(5)V99

304

Employer Medicare Tax Gross

7

S9(5)V99

311

Employer Medicare Withheld

7

S9(5)V99

318

Retirement System ID

2

X(2)

320

Retirement Rate

5

SV9(5)

325

Gross Subject Retirement

7

S9(5)V99

332

Retirement Withheld

7

S9(5)V99

339

Retirement State Share Amount

7

S9(5)V99

346

Retirement Employer Paid Member Contribution

7

S9(5)V99

353

Gross

7

S9(5)V99

360

LC 4800 Gross/Offset Amount

7

S9(5)V99

367

Net

7

S9(5)V99

374

Clearance Number

5

9(5)

379

Key Pay Period

1

X

380

Lump Sum Pay Period (YYMM)

4

X(4)

384

Filler

97

X(97)

481

Deduction Segment Count

4

S9(4)

 

Segment 2, Segment Occurs = 36 times, Segment Size = 93

Start
Position

Description

Length

Format

1

Deduction Code

3

X(3)

4

Organization Code

3

X(3)

7

Restriction Code

1

X

8

Deduction Amount

7

S9(5)V99

15

Deduction Pay Period (CCYYMM)

6

X(6)

21

Deduction Pay Period Type

1

X

22

Deduction Tax Gross Indicator

1

X

23

Filler

8

X(15)

31

Deduction Type

2

X(2)

 

Note:  The fields below are dependent on Deduction Type. They are included in the segment size of 93.  

Deduction Type = AR (Accounts Receivable)

Start
Position

Description

Length

Format

33

Accounts Receivable Number

5

X(5)

38

Payment Type

1

X

39

Taxable Gross

7

S9(5)V99

46

Filler

48

X(48)

 

Deduction Type = BL (Basic Life)

Start
Position

Description

Length

Format

33

State Share Amount

5

S9(3)V99

38

Agency Code

3

X(3)

41

Reporting Unit

3

X(3)

44

Collective Bargaining ID

3

X(3)

47

Collective Bargaining Authority

1

X

48

Filler

46

X(46)

 

Deduction Type = GA (Garnishment)

Start
Position

Description

Length

Format

33

Effective Date (CCYYMMDD)

8

X(8)

41

Termination Date (CCYYMMDD)

8

X(8)

49

Original Amount

7

S9(5)V99

56

Original Amount Owed To Agency

7

S9(5)V99

63

Agency Amount Applied

7

S9(5)V99

70

Tax Standard Deduction Amount Indicator

1

X

71

Tax Dependents

2

99

73

Maximum Amount

7

S9(5)V99

80

Support Exemption Amount

7

S9(5)V99

87

Support Amount Per Month

7

S9(5)V99

 

Deduction Type = GI (Government Life Insurance)

Start
Position

Description

Length

Format

33

Prefix

2

X(2)

35

Policy Number

8

X(8)

43

Filler

51

X(51)

 

Deduction Type = HB, HD, HV, FA, FB, FC, FD, FH

(Health Benefit, Dental Plan, Vision Care, Flexible Benefit Deduction)

Start
Position

Description

Length

Format

33

State Share Amount

5

S9(3)V99

38

Administration Cost

5

S9(3)V99

43

Party Rate Code

1

X

44

Filler

1

X

45

Agency Code

3

X(3)

48

Reporting Unit

3

X(3)

51

Collective Bargaining ID

3

X(3)

54

Collective Bargaining Authority

1

X

55

Filler

1

X

56

Matching Deduction Code

3

X(3)

59

Matching Organization Code

3

X(3)

62

Matching Deduction Indicator

1

X

63

Filler

31

X(31)

 

Deduction Type = ZS, ZM, SS, MD

(Mandatory Arrears Social Security and Medicare)

Start
Position

Description

Length

Format

33

Issue Century

2

X(2)

35

Issue Year

2

X(2)

37

Fiscal Century

2

X(2)

39

Fiscal Year

2

X(2)

41

Quarter Code

1

X

42

Agency Code

3

X(3)

45

Reporting Unit

3

X(3)

48

Employee Social Security/Medicare Tax Gross

7

S9(5)V99

55

Employer Social Security/Medicare Tax Gross

7

S9(5)V99

62

Employer Social Security/Medicare Tax Withheld

7

S9(5)V99

69

Filler

25

X(25)

 

Deduction Type = PG (General Service Parking Fee)

Start
Position

Description

Length

Format

33

Lot Number

2

X(2)

34

Filler

59

X(59)

 

Deduction Type = RJ, RP, RT (Retroactive Retirement Adjustment)

Start
Position

Description

Length

Format

33

Salary Type

1

X

34

Salary Rate

7

S9(5)V99

41

Gross Subject to Retirement

7

S9(5)V99

48

State Share Amount

7

S9(5)V99

55

Retirement Rate

5

SV9(5)

60

Retirement System ID

2

X(2)

62

Agency Code

3

X(3)

65

Reporting Unit

3

X(3)

68

Payment Type

1

X

69

Adjustment Code

1

X

70

Employer Paid Member Contribution Amount

7

S9(5)V99

77

Collective Bargaining ID

3

X(3)

80

Collective Bargaining Authority

1

X

81

Filler

13

X(13)

 

Deduction Type = ZF, ZT (Mandatory Federal/State Tax)

Start
Position

Description

Length

Format

33

Issue Century

2

X(2)

35

Issue Year

2

X(2)

37

Tax Gross

7

S9(5)V99

44

Filler

50

X(50)

 

Format X - Alphanumeric

Format 9 - Number

Format S - Sign (+ or -)

 

 

 

Last Updated:  July 13, 2004