SPL_DOMAIN_LIST (SQL Table)	Index Back
Supply Planning Domain List List of available domains that can start a Planning IIntance

SPL_DOMAIN_LIST

(SQL Table)

Supply Planning Domain List

List of available domains that can start a Planning IIntance

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBTYPE Character(20) VARCHAR2(20) NOT NULL Optimization Problem Type (see PSOPTPRBTYPE).
Default Value: SCP
Prompt Table: PSOPTPRBTYPE

2 DOMAIN_ID Character(234) VARCHAR2(234) NOT NULL Domain ID

3 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

4 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default
Y/N Table Edit
Default Value: N

5 LAST_UPDATE_DTTM 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	PROBTYPE	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Type (see PSOPTPRBTYPE). Default Value: SCP Prompt Table: PSOPTPRBTYPE
2	DOMAIN_ID	Character(234)	VARCHAR2(234) NOT NULL	Domain ID
3	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
4	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Default Y/N Table Edit Default Value: N
5	LAST_UPDATE_DTTM	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.