BUSINESS_UNITSO_IDLASTUPDDTTMSO_ACTION_TYPECOM=Comment
NEW=New
OPN=Open To
OWN=Ownership
PRI=Priority
STA=Status
C=Closed
D=Draft
I=In Process
N=New
O=Open
X=Canceled
RS_SO_STATUS_VW(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , SO_ID , LASTUPDDTTM , SO_ACTION_TYPE , SO_STATUS , LASTUPDOPRID , DESCR FROM PS_RS_SO_HDR_AUDIT WHERE SO_ACTION_TYPE = 'STA' |
| # | 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 | SO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Service Order Status
C=Closed D=Draft I=In Process N=New O=Open X=Canceled |
| 6 | 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. |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |