| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRIDDESC_VW
|
| 2 |
FO_DATE |
Date(10) |
DATE NOT NULL |
Date
Default Value: %DATE
|
| 3 |
FO_AGENDA_ID |
Character(26) |
VARCHAR2(26) NOT NULL |
Agenda ID
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPRDEFTBL_UPG.BUSINESS_UNIT
Prompt Table:
BUSUNITTBLF_UPG
|
| 5 |
FO_TIME |
Time(15) |
TIMESTAMP |
Time
|
| 6 |
EVENT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Event Type
Prompt Table:
FO_EVENT_DST_VW
|
| 7 |
CONTACT_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Contact Method
A=Apply Online URL
C=Telephone Call
E=Email
P=In-Person
V=Verbal
W=In-Writing
|
| 8 |
COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Completed
Y/N Table Edit
Default Value: N
|
| 9 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
FO_EMPLID_SRCH
|
| 10 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
Prompt Table:
SP_SETID_NONVW
|
| 11 |
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.
Prompt Table:
FO_CST_AL_CNT_V
|
| 12 |
CONTACT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Contact SetID
Prompt Table:
SP_SETID_NONVW
|
| 13 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
FO_CNTCT_SET_VW
|
| 14 |
ORDER_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Order ID
Prompt Table:
FO_ORDER_VW
|
| 15 |
FO_ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Assignment ID
Prompt Table:
FO_ASGN_PRMT_VW
|
| 16 |
AUTO_PLANNED_EVENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Planned Event
Y/N Table Edit
Default Value: N
|
| 17 |
HISTORY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
HIstory Type
AGDA=Agenda
Default Value: AGDA
|
| 18 |
FO_TRANSACTION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Transaction ID
|
| 19 |
END_TIME |
Time(15) |
TIMESTAMP NOT NULL |
End of Shift
|
| 20 |
AGENDA_PRIORITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Agenda Priority
1=High
2=Medium
3=Low
Default Value: 2
|
| 21 |
ORIGINAL_DATE |
DateTime(26) |
TIMESTAMP |
Original Date Time
Default Value: %DATETIME
|
| 22 |
ACTUAL_END_DATE |
DateTime(26) |
TIMESTAMP |
Actual End Date Time
|
| 23 |
PREVOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Previous User ID
Default Value: FOAGENDADTL_UPG.OPRID
|
| 24 |
DATETIME_ADDED |
DateTime(26) |
TIMESTAMP |
DateTime Added
|
| 25 |
COMMENTS_2000 |
Long Character |
CLOB |
Comment Text
|