RS_APPT_TYPEACT=Activity
ASN=Assignment
DAY=All Day Event
MTG=Meeting
RS_APPT_IDDefault Value: NEXT
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AM_NONVW
1=Labor
2=Tools
3=Material
Prompt Table: %EDITTABLE
RS_APPT_SRCH_VW(SQL View) |
Index Back |
|---|---|
Appt search viewThe view for searching appointment |
| SELECT RS_APPT_TYPE , RS_APPT_ID , EMPLID , BUSINESS_UNIT_AM , ASSET_ID , BUSINESS_UNIT_WO , WO_TASK_ID , WO_ID , RES_LN_NBR , RSRC_TYPE , RS_DATE , RS_END_DATE , TASK_TYPE , TIME_START , SCHEDULED_HRS FROM %Table(RS_APPOINTMENT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RS_APPT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Appointment Type
ACT=Activity ASN=Assignment DAY=All Day Event MTG=Meeting |
| 2 | RS_APPT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Appointment Id
Default Value: NEXT |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 5 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 6 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL | Business Unit Work Order |
| 7 | WO_TASK_ID | Number(5,0) | INTEGER NOT NULL | Task Number |
| 8 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 9 | RES_LN_NBR | Number(5,0) | INTEGER NOT NULL | Resource Line No. |
| 10 | RSRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor 2=Tools 3=Material |
| 11 | RS_DATE | Date(10) | DATE NOT NULL | This field is used to display dates |
| 12 | RS_END_DATE | Date(10) | DATE | End date |
| 13 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL |
Task Category
Prompt Table: %EDITTABLE |
| 14 | TIME_START | Time(15) | TIMESTAMP NOT NULL | Start Time |
| 15 | SCHEDULED_HRS | Signed Number(10,4) | DECIMAL(8,4) NOT NULL | Scheduled Hours |