Payment History Extract - SCO Production Format File Description

This file is a payment history extract file. It is created by selecting the SCO PROD (Production) format from the payment history extract screen. Selecting this format will result in a payment history file which includes the same fields as the business month payment history tape (DESCENT. Format), but which contains packed fields. 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.SCOPROD.userid

  • Record Length: 3409

  • 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

3

X(3)

52

Earnings ID #1

4

X(4)

56

Earnings ID #2

4

X(4)

60

Earnings ID #3

4

X(4)

64

Collective Bargaining ID

3

X(3)

69

Name, First Int.

1

X

70

Name, Middle Int.

1

X

71

Name, Last

21

X(21)

92

Issue Date (CCYYMMDD)

8

X(8)

100

Original Issue Date (CCYYMMDD)

8

X(8)

108

Transaction Code

3

X(3)

111

PSD File Number

9

X(9)

120

Register Warrant Indicator

1

X

121

Class Type

1

X

122

Payment Type

1

X

123

Payment Type Suffix

1

X

124

Adjustment Code

1

X

125

Accounts Receivable Code

1

X

126

Roll Code

1

X

127

Range Code

2

X(2)

129

FLSA

4

X(4)

133

Salary Type

1

X

134

Gross Type

1

X

135

Shift Differential

1

X

136

Over Time Code

1

X

137

Time Base Numerator

3

X(3)

140

Time Base Denominator

3

X(3)

143     

Days Paid

2

P2     

143

Units Paid

4

P4.2

145

Hours Paid

2

P3.2

148

Days Docked

2

P2

150

Hours Docked

2

P2.2

152

Federal Tax Gross, Employee

4

P4.2

156

Federal Tax Withheld, Employee

4

P4.2

160

State Code #1

2

X(2)

162

State Tax Gross, Employee

4

P4.2

166

State Tax Withheld, Employee

4

P4.2

170

State Code #2

2

X(2)

172

State Tax Gross, Employee 2

4

P4.2

176

State Tax Withheld, Employee 2

4

P4.2

180

Social Security Tax Gross, Employee   

4

P4.2

184

Social Security Withheld, Employee

4

P4.2

188

Medicare Tax Gross, Employee

4

P4.2

192

Medicate Tax Withheld, Employee

4

P4.2

196

Gross Pay

4

P4.2

200

Retirement System ID

2

X(2)

213

Fiscal Year End (CCYY)

4

X(4)

217

Special Pay

1

X

218

Record Type

1

X

219

Summarized Warrant

1

X

220

Reported Redeposit

1

X

221

Locked In Premium Indicator

1

X

222

Account Receivable Type

1

X

223

Lump Sum Pay Period (CCYYMM)

6

X(6)

231

Actual Rate

4

P4.2

235

Salary Rate

4

P4.2

239

Salary Full

4

P4.2

243

Married Federal

1

X

244

Tax Exemptions Federal

2

9(2)

250

Married State

1

X

251

Tax Exemptions State

2

9(2)

253

Itemized Allowances State

2

9(2)

259

Social Security Tax Gross, Employer

4

P4.2

263

Social Security Withheld, Employer

4

P4.2

267

Medicare Tax Gross, Employer

4

P4.2

271

Medicate Tax Withheld, Employer

4

P4.2

275

Retirement Rate

3

P3.5

278

Gross Subject Retirement

4

P4.2

282

Retirement Withheld

4

P4.2

286

Retirement State Share Amount

4

P4.2

290

Retirement EPMC Amount

4

P4.2

294

IDL Offset

4

P4.2

298

Net Pay

4

P4.2

302

Clearance Number

5

X(5)

307

Budget Function

3

X(3)

310

Original Suspense Date (CCYYMMDD)

8

X(8)

318

Filler

104

X(104)

 

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

Note:  The fields below Deduction Type are dependent on Deduction Type.

They are included in the segment size of 83.

Start
Position

 

Description

 

Length

 

Format

1

Deduction ID

6

X(6)

1

Deduction Code

3

X(3)

4

Organization Code

3

X(3)

7

Restriction Code

1

X

8

Deduction Amount

4

P4.2

12

Deduction Pay Period (CCYYMM)

6

X(6)

18

Deduction Pay Period Type

1

X

19

Deduction Tax Gross Indicator

1

X

32

Deduction Type

2

X(2)

 

Deduction Type = AR (Accounts Receivable)

Start
Position

 

Description

 

Length

 

Format

34

Accounts Receivable Number

5

X(5)

39

Payment Type

1

X

40

Taxable Gross

4

P4.2

 

Deduction Type = BL (Basic Life)

Start
Position

 

Description

 

Length

 

Format

34

State Share Amount

3

P3.2

37

Agency Code

3

X(3)

40

Reporting Unit

3

X(3)

43

Collective Bargaining ID

3

X(3)

46

Collective Bargaining Authority

1

X

34

Effective Date (CCYYMMDD)

8

X(8)

42

Termination Date (CCYYMMDD)

8

X(8)

50

Original Amount

4

P4.2

54

Original Amount Owed To Agency

4

P4.2

58

Agency Amount Applied

4

P4.2

62

Tax Dependents

2

P2

64

Maximum Amount

4

P4.2

68

Support Exemption Amount

4

P4.2

72

Support Amount Per Month

4

P4.2

76

Tax Standard Deduction Amount Indicator

1

X

 

Deduction Type = GI (Government Life Insurance)

Start
Position

 

Description

 

Length

 

Format

34

Prefix

2

X(2)

36

Policy Number

8

X(8)

 

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

Start
Position

 

Description

 

Length

 

Format

34

State Share Amount

3

P3.2

37

Administration Cost

3

P3.2

40

Party Rate Code

1

X

41

Health Benefits Plan

1

X

42

Agency Code

3

X(3)

45

Reporting Unit

3

X(3)

 

Deduction Type = MD, ZM (Mandatory Arrears Medicare)

Start
Position

 

Description

 

Length

 

Format

34

Issue Century

2

X(2)

36

Issue Year

2

X(2)

38

Fiscal Century

2

X(2)

40

Fiscal Year

2

X(2)

42

Quarter Code

1

X

43

Agency Code

3

X(3)

45

Reporting Unit

3

X(3)

49

Employee Medicate Tax Gross

4

P4.2

53

Employer Medicare Tax Gross

4

P4.2

57

Employer Medicare Tax Withheld

4

P4.2

34

Salary Type

1

X

37

Salary Rate

4

P4.2

39

Gross Subject to Retirement

4

P4.2

43

State Share Amount

4

P4.2

47

Retirement Rate

3

P3.5

50

Retirement System ID

2

X(2)

52

Agency Code

3

X(3)

55

Reporting Unit

3

X(3)

58

Payment Type

1

X

59

Adjustment Code

1

X

60

Employer Paid Member Contribution Amt.

4

P4.2

64

Collective Bargaining ID

3

X(3)

67

Collective Bargaining Authority

1

X

 

Deduction Type = SS, ZS (Mandatory Arrears Social Security)

Start
Position

 

Description

 

Format

 

Length

34

Issue Century

2

X(2)

36

Issue Year

2

X(2)

38

Fiscal Century

2

X(2)

40

Fiscal Year

2

X(2)

42

Quarter Code

1

X

43

Agency Code

3

X(3)

45

Reporting Unit

3

X(3)

49

Employee Social Security Tax Gross

4

P4.2

53

Employer Social Security Tax Gross

4

P4.2

57

Employer Social Security Withheld

4

P4.2

 

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

Start
Position

 

Description

 

Format

 

Length

34

Issue Century

2

X(2)

36

Issue Year

2

X(2)

38

Tax Gross

4

P4.2

 

Format X - Alphanumeric

Format 9 - Number

Format S - Sign (+ or -)

Format V - Implied Decimal Point