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
D=Detail
N=Node
Prompt Table: DEPT_ALL_VW
RS_SO_HDR_AUDIT(SQL Table) |
Index Back |
|---|
| # | 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_PRIORITY | Character(10) | VARCHAR2(10) NOT NULL | Service Order Priority |
| 6 | SO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Service Order Status
C=Closed D=Draft I=In Process N=New O=Open X=Canceled |
| 7 | BUSINESS_UNIT_HR | Character(5) | VARCHAR2(5) NOT NULL | Business Unit HR |
| 8 | TREE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Tree SetID |
| 9 | NODE_DETAIL | Character(1) | VARCHAR2(1) NOT NULL |
Tree Node or Tree detail Value
D=Detail N=Node |
| 10 | OWNERSHIP_ID | Character(30) | VARCHAR2(30) NOT NULL |
Owning Organization
Prompt Table: DEPT_ALL_VW |
| 11 | 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. |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |