RETRO_UNSH_RQST (SQL Table)	Index Back
Retro Unsheeted Request This table is used when a retro request has been loaded to paysheets, and then the paysheet is unsheeted. If a new retro request has been created in the meantime, the original retro request is Cancelled since we only allow 1 active request at any time. The key fields on this record are for the new retro request, and the RETRO_SEQ_OTHER field is the reference to the request that was unsheeted/cancelled.

RETRO_UNSH_RQST

(SQL Table)

Retro Unsheeted Request

This table is used when a retro request has been loaded to paysheets, and then the paysheet is unsheeted. If a new retro request has been created in the meantime, the original retro request is Cancelled since we only allow 1 active request at any time. The key fields on this record are for the new retro request, and the RETRO_SEQ_OTHER field is the reference to the request that was unsheeted/cancelled.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RETROPAY_SEQ_NO Character(15) VARCHAR2(15) NOT NULL Retro Pay Sequence Number

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 RETRO_SEQ_OTHER Character(15) VARCHAR2(15) NOT NULL This is the retropay sequence number for the retro request that is being unsheeted. It provides a cross-reference to the new retro request, if one exists.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RETROPAY_SEQ_NO	Character(15)	VARCHAR2(15) NOT NULL	Retro Pay Sequence Number
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	RETRO_SEQ_OTHER	Character(15)	VARCHAR2(15) NOT NULL	This is the retropay sequence number for the retro request that is being unsheeted. It provides a cross-reference to the new retro request, if one exists.