RS_SO_OWNER_VW

(SQL View)
 Index Back

SELECT BUSINESS_UNIT , SO_ID , LASTUPDDTTM , SO_ACTION_TYPE , BUSINESS_UNIT_HR , TREE_SETID , NODE_DETAIL , OWNERSHIP_ID , LASTUPDOPRID , DESCR FROM PS_RS_SO_HDR_AUDIT WHERE SO_ACTION_TYPE = 'OWN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
3 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.
4 SO_ACTION_TYPE Character(3) VARCHAR2(3) NOT NULL Action Type
COM=Comment
NEW=New
OPN=Open To
OWN=Ownership
PRI=Priority
STA=Status
5 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR
6 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID
7 NODE_DETAIL Character(1) VARCHAR2(1) NOT NULL Tree Node or Tree detail Value
D=Detail
N=Node
8 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description