REQ_RC_SHIP (SQL Table)	Index Back
Req Reopen Line Schedule Used to store records affected by the Req Recon process. The records will be used to reopen records.

REQ_RC_SHIP

(SQL Table)

Req Reopen Line Schedule

Used to store records affected by the Req Recon process. The records will be used to reopen records.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

5 CURR_STATUS Character(1) VARCHAR2(1) NOT NULL Current Status
A=Approved
C=Closed
D=Denied
H=Hold
O=Open
P=Pending
X=Canceled

6 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
5	CURR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Current Status A=Approved C=Closed D=Denied H=Hold O=Open P=Pending X=Canceled
6	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.