PV_OS_HDR_VW (SQL View)	Index Back
Order Sheet Header PSFTEP-828 New view

PV_OS_HDR_VW

(SQL View)

Order Sheet Header

PSFTEP-828 New view

SELECT DISTINCT A.SETID , A.PV_ORD_SHEET_ID , A.BUSINESS_UNIT , A.PV_OS_DESCR , A.PV_OS_STATUS , A.VALIDATION_STATUS , MAX(B.PV_VALIDATE_DTTM) , A.IN_PROCESS_FLG , A.OPRID_ENTERED_BY , A.ENTERED_DTTM , A.OPRID_MODIFIED_BY , A.LAST_DTTM_UPDATE FROM PS_PV_OS_HDR A , PS_PV_OS_LINE B WHERE A.SETID = B.SETID AND A.PV_ORD_SHEET_ID = B.PV_ORD_SHEET_ID GROUP BY A.SETID , A.PV_ORD_SHEET_ID , A.BUSINESS_UNIT , A.PV_OS_DESCR , A.PV_OS_STATUS , A.VALIDATION_STATUS , A.IN_PROCESS_FLG , A.OPRID_ENTERED_BY , A.ENTERED_DTTM , A.OPRID_MODIFIED_BY , A.LAST_DTTM_UPDATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 PV_ORD_SHEET_ID Character(20) VARCHAR2(20) NOT NULL Order Sheet ID

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUPRCR_NONVW

4 PV_OS_DESCR Character(30) VARCHAR2(30) NOT NULL Order Sheet Description

5 PV_OS_STATUS Character(1) VARCHAR2(1) NOT NULL Order Sheet Status
A=Active
I=Inactive
O=Open
Default Value: O

6 VALIDATION_STATUS Character(1) VARCHAR2(1) NOT NULL Validation Status
E=Error
I=Initial
V=Valid

7 PV_FIELD_DATE Date(10) DATE Date Value

8 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

9 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

10 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime

11 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.

12 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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	PV_ORD_SHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Order Sheet ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUPRCR_NONVW
4	PV_OS_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Order Sheet Description
5	PV_OS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Order Sheet Status A=Active I=Inactive O=Open Default Value: O
6	VALIDATION_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Validation Status E=Error I=Initial V=Valid
7	PV_FIELD_DATE	Date(10)	DATE	Date Value
8	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
9	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
10	ENTERED_DTTM	DateTime(26)	TIMESTAMP	Entered Datetime
11	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
12	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.