EMPLIDPrompt Table:
PERSONAL_DATA
Set Control Field: EMPLID
BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
SO_IDSO_LINERS_WO_RR_SRH_VW(SQL View) |
Index Back |
|---|---|
Worker RR search viewSearch view for resources and resource requests. |
| SELECT A.EMPLID , B.BUSINESS_UNIT , B.SO_ID , B.SO_LINE , B.START_DT , B.DESCR FROM %Table(RS_WORKER_TBL) A , %Table(RS_SO_LINE) B |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSONAL_DATA
|
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 3 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 4 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |