PAY_CHECK_DEAD (SQL Table)	Index Back
Unusable Checks This record contains information about canceld, voided or otherwise bypassed checks.

PAY_CHECK_DEAD

(SQL Table)

Unusable Checks

This record contains information about canceld, voided or otherwise bypassed checks.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
Prompt Table: PAY_FORM_TBL

2 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.

3 DEAD_CHECK_REASON Character(1) VARCHAR2(1) NOT NULL Dead Check Reason
R=Check Reprinted
S=Check Number Skipped

4 PAYCHECK_NBR_REPL Number(15,0) DECIMAL(15) NOT NULL Check# Replacing Dead Check

5 FORMID_REPLACED_BY Character(6) VARCHAR2(6) NOT NULL FormId Replacng earlier FormID

6 PAY_SHEET_SRC Character(1) VARCHAR2(1) NOT NULL Source of Paysheet
F=FLSA Paysheet
K=Batch Final Check
L=Online Final Check
O=On-line Paysheet
P=Paysheet Load
S=Regular Paysheet
Default Value: S

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification Prompt Table: PAY_FORM_TBL
2	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
3	DEAD_CHECK_REASON	Character(1)	VARCHAR2(1) NOT NULL	Dead Check Reason R=Check Reprinted S=Check Number Skipped
4	PAYCHECK_NBR_REPL	Number(15,0)	DECIMAL(15) NOT NULL	Check# Replacing Dead Check
5	FORMID_REPLACED_BY	Character(6)	VARCHAR2(6) NOT NULL	FormId Replacng earlier FormID
6	PAY_SHEET_SRC	Character(1)	VARCHAR2(1) NOT NULL	Source of Paysheet F=FLSA Paysheet K=Batch Final Check L=Online Final Check O=On-line Paysheet P=Paysheet Load S=Regular Paysheet Default Value: S