RS_ASSGN_OSL_VW(SQL View) |
Index Back |
|---|---|
Service Order Line |
| SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.ACTIVITY_ID , A.RESOURCE_ID , A.QTY_INTEGER , A.CUST_ID , A.ADDRESS_SEQ_NUM , A.START_DT , A.END_DT , A.LATE_START_DT , A.EST_DAYS , A.PERIOD_DAYS , A.PART_TIME_FLG , A.DESCR , A.PROJ_ROLE , A.KEY_REQS , A.SO_LINE_STATUS , A.APPROVAL_STATUS , A.NONBILLABLE_FLAG , A.BID_FLAG , A.DISTANCE , A.LASTUPDOPRID , A.LASTUPDDTTM , A.COMMENTS_2000 FROM %Table(RS_SO_LINE) A WHERE A.SO_LINE_STATUS NOT IN ('A','C') |
| # | 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 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 4 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 5 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |
| 6 | QTY_INTEGER | Number(11,0) | DECIMAL(11) NOT NULL | Quantity Rounded to 0 Decimals |
| 7 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 8 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: RS_CUST_VW |
| 9 | START_DT | Date(10) | DATE | Start Date |
| 10 | END_DT | Date(10) | DATE | End Date |
| 11 | LATE_START_DT | Date(10) | DATE | Late Start Date |
| 12 | EST_DAYS | Number(5,0) | INTEGER NOT NULL | Estimated number of days |
| 13 | PERIOD_DAYS | Number(5,0) | INTEGER NOT NULL | Number of Work Days |
| 14 | PART_TIME_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Part Time
Y/N Table Edit Default Value: N |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 16 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: PROJ_ROLE |
| 17 | KEY_REQS | Character(100) | VARCHAR2(100) NOT NULL | Key Requirements |
| 18 | SO_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Line Status
A=Closed C=Cancel O=Open Default Value: O |
| 19 | APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
A=Approved D=Denied E=Sent Back for Revision H=On Hold I=Initial M=Resubmitted P=In Process R=Rerouted S=Submitted Default Value: I |
| 20 | NONBILLABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Shadow Consultants Allowed
Y/N Table Edit Default Value: N |
| 21 | BID_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Worker Bids Accepted
Y/N Table Edit Default Value: N |
| 22 | DISTANCE | Number(8,2) | DECIMAL(7,2) NOT NULL | Distance Traveled |
| 23 | 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. |
| 24 | 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. |
| 25 | COMMENTS_2000 | Long Character | CLOB | Comment Text |