WCS_LK_SAL_VW

(SQL View)

SELECT LOOKUP_ID , EFFDT , EFF_STATUS , LOOKUP_TBL_TYPE , DESCR FROM PS_WCS_LK_DEFN WHERE LOOKUP_TBL_TYPE = 'SALMATRIX'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LOOKUP_ID Character(15) VARCHAR2(15) NOT NULL Main unique identifier for Configurable Matrices.

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: I

4 LOOKUP_TBL_TYPE Character(10) VARCHAR2(10) NOT NULL This is an indication of a Configurable Matrix's intended use, combining it's source orientations and result usage. It classifies Configurable Matrices and allows applications a way to identify those Matrices they are capable of supporting.
Prompt Table: WCS_LK_TYPE_TBL

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LOOKUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Main unique identifier for Configurable Matrices.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: I
4	LOOKUP_TBL_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This is an indication of a Configurable Matrix's intended use, combining it's source orientations and result usage. It classifies Configurable Matrices and allows applications a way to identify those Matrices they are capable of supporting. Prompt Table: WCS_LK_TYPE_TBL
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description