SPRS User Guide –
SPRS Payroll Input Record Matrix
520 Record
520 Record – Entitlement Transaction
Field Requirements by Entitlement Code | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Data Fields | 1XM | BIL | BMI | BMO | BRP | BSY | CAI | CAO | CER | CLO | CON | CPD | CPI | CSS | CTP | DSP | DVP | EDL | FFC |
AGY NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
DOC NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
REC ID | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
SSN | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PMT SEQ NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PMT TRN TYPE | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
APPR YEAR | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PCA/INDEX | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
OBJECT | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PAY PERIOD START | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PAY PERIOD END | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
ENT CD | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
JOB NO | M | X | X | X | X | M | X | X | X | X | X | M | X | X | X | X | X | X | X |
ENT GROSS AMT | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M |
ENT ACTUAL HOURS | X | X | X | X | X | M | X | X | X | X | X | X | X | X | M | M | M | X | O |
ENT ACTUAL DAYS | X | X | X | X | X | X | X | X | X | X | X | M | X | X | X | X | X | X | X |
520 Record – Entitlement Transaction Continued
Field Requirements by Entitlement Code | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Data Fields | FFL | FFQ | FIR | HAZ | INC | LOG | LSV | NHB | OTP | PBN | PDI | PDO | RIP | SHD | SNP | SRB | SSC | STI | SUP |
AGY NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
DOC NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
REC ID | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
SSN | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PMT SEQ NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PMT TRN TYPE | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
APPR YEAR | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PCA/INDEX | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
OBJECT | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PAY PERIOD START | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
PAY PERIOD END | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
ENT CD | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
JOB NO | X | X | X | X | X | X | X | X | X | M | X | X | X | X | X | X | X | X | X |
ENT GROSS AMT | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M |
ENT ACTUAL HOURS | O | O | X | X | X | X | M | X | M | X | X | X | X | O | X | X | X | X | X |
ENT ACTUAL DAYS | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
Field Requirements Key
Code | Description |
---|---|
KM | Key/Mandatory |
M | Mandatory |
O | Optional |
X | Protected (Not Applicable for Transaction) |
Date | Updates |
---|---|
05/08/2020 | Added entitlement codes FFC (FFCRA Paid Sick Care), FFL (FFCRA FMLA Paid Leave) and FFQ (FFCRA Paid Sick Quarantine) |
06/01/2011 | Removed entitlement DHS (Food Stamp Program Bonus Pay) and added entitlement SNP (SNAP Program Bonus) |