RS_DF_RR_OPT_W

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

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

3 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

4 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

5 START_DT Date(10) DATE Start Date

6 END_DT Date(10) DATE End Date

7 EST_DAYS Number(5,0) INTEGER NOT NULL Estimated number of days

8 PERIOD_DAYS Number(5,0) INTEGER NOT NULL Number of Work Days

9 PART_TIME_FLG Character(1) VARCHAR2(1) NOT NULL Part Time
Y/N Table Edit

10 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

11 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

12 DISTANCE Number(8,2) DECIMAL(7,2) NOT NULL Distance Traveled

13 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To

14 LASTUPDDTTM 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.

15 KEY_REQS Character(100) VARCHAR2(100) NOT NULL Key Requirements

16 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals

17 EXPRESS_SEARCH_FLG Character(1) VARCHAR2(1) NOT NULL Express Search

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
4	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
5	START_DT	Date(10)	DATE	Start Date
6	END_DT	Date(10)	DATE	End Date
7	EST_DAYS	Number(5,0)	INTEGER NOT NULL	Estimated number of days
8	PERIOD_DAYS	Number(5,0)	INTEGER NOT NULL	Number of Work Days
9	PART_TIME_FLG	Character(1)	VARCHAR2(1) NOT NULL	Part Time Y/N Table Edit
10	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
11	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
12	DISTANCE	Number(8,2)	DECIMAL(7,2) NOT NULL	Distance Traveled
13	ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	Assigned To
14	LASTUPDDTTM	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.
15	KEY_REQS	Character(100)	VARCHAR2(100) NOT NULL	Key Requirements
16	QTY_INTEGER	Number(11,0)	DECIMAL(11) NOT NULL	Quantity Rounded to 0 Decimals
17	EXPRESS_SEARCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Express Search