WM_STATDSPLY_VW (SQL View)	Index Back
Work Order Status Display rule View WM_STATDSPLY_VW returns ALL fields defined in WM_STATDSPLY_LN Status Display Rules, including those on sub records entered as fields in the Status Display Rules. However, if a field is explicity listed in the Status Display Rules, it takes precedence over the Sub Record field's display action; this view's SQL will return the appropriate row. This enhancement allows users to add new user-defined Chart Fields (CF's) to the appropriate CF sub-records and the Status Framework will then automatically apply the appropriate display action to any new CF's added to the sub record.

WM_STATDSPLY_VW

(SQL View)

Work Order Status Display rule

View WM_STATDSPLY_VW returns ALL fields defined in WM_STATDSPLY_LN Status Display Rules, including those on sub records entered as fields in the Status Display Rules. However, if a field is explicity listed in the Status Display Rules, it takes precedence over the Sub Record field's display action; this view's SQL will return the appropriate row. This enhancement allows users to add new user-defined Chart Fields (CF's) to the appropriate CF sub-records and the Status Framework will then automatically apply the appropriate display action to any new CF's added to the sub record.

SELECT SD.CONTEXT_ID , SD.COMPONENT_ID , SD.INTERNAL_STATUS , SD.WO_STATUS_TYPE , SD.RECNAME , SD.FIELDNAME , SD.DISPLAY_ACTION FROM PS_WM_STATDSPLY_LN SD , PSRECFIELDDB RF WHERE SD.RECNAME = RF.RECNAME AND SD.FIELDNAME = RF.FIELDNAME UNION SELECT SD2.CONTEXT_ID , SD2.COMPONENT_ID , SD2.INTERNAL_STATUS , SD2.WO_STATUS_TYPE , SD2.RECNAME , RF2.FIELDNAME , SD2.DISPLAY_ACTION FROM PS_WM_STATDSPLY_LN SD2 , PSRECFIELDDB RF2 , PSRECFIELD F WHERE SD2.RECNAME = F.RECNAME AND SD2.FIELDNAME = F.FIELDNAME AND F.SUBRECORD = 'Y' AND RF2.RECNAME = SD2.FIELDNAME AND NOT EXISTS ( SELECT 'X' FROM PS_WM_STATDSPLY_LN SD , PSRECFIELDDB RF WHERE SD.RECNAME = RF.RECNAME AND SD.FIELDNAME = RF.FIELDNAME AND SD.RECNAME = SD2.RECNAME AND SD.FIELDNAME = RF2.FIELDNAME AND SD.COMPONENT_ID = SD2.COMPONENT_ID AND SD.CONTEXT_ID = SD2.CONTEXT_ID AND SD.INTERNAL_STATUS = SD2.INTERNAL_STATUS)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTEXT_ID Character(30) VARCHAR2(30) NOT NULL Context ID

2 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

3 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created

4 WO_STATUS_TYPE Character(1) VARCHAR2(1) NOT NULL Status Type
1=Header
2=Task
3=Service Request

5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN

6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: WM_RECFIELD

7 DISPLAY_ACTION Character(2) VARCHAR2(2) NOT NULL Display Action
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTEXT_ID	Character(30)	VARCHAR2(30) NOT NULL	Context ID
2	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
3	INTERNAL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Internal Status 01=Open 02=Awaiting Schedule 03=Scheduled 04=Work In Progress 05=Complete 06=Closed 07=Canceled 08=On Hold 09=Work Order Created
4	WO_STATUS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Status Type 1=Header 2=Task 3=Service Request
5	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: WM_RECFIELD
7	DISPLAY_ACTION	Character(2)	VARCHAR2(2) NOT NULL	Display Action Default Value: 1