| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INQUIRY |
Character(10) |
VARCHAR2(10) NOT NULL |
Saved Search
Prompt Table:
FO_AGND_INQ_CRT
Set Control Field: OPRID
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRIDDESC_VW
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
SERVICE_GROUP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Group Id
Prompt Table:
FO_SVC_GRP_VW
|
| 5 |
AGENDA_PRIORITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Agenda Priority
1=High
2=Medium
3=Low
|
| 6 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
Prompt Table:
SP_SETID_NONVW
|
| 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.
Prompt Table:
FO_CUSTOMER_SR
|
| 8 |
CONTACT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Contact SetID
Prompt Table:
SP_SETID_NONVW
|
| 9 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
FO_CNTCT_SR
|
| 10 |
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
|
| 11 |
CANDIDATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Candidate Type
A=Applicant
E=Employee
|
| 12 |
CANDIDATE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Used as a general ID for anything from Employee id to other types of ID like asset and material.
Prompt Table:
FO_CANDIDATE_W
|
| 13 |
OWNERSHIP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Owning Organization
Prompt Table:
FO_BRANCH_TBL
|
| 14 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 15 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
Prompt Table:
FO_ORDR_SRCH_VW
|
| 16 |
SO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Line Number
Prompt Table:
FO_ORDR_LIN_SRC
|
| 17 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 18 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 19 |
START_DATE_FROM |
Date(10) |
DATE |
State date
|
| 20 |
START_DATE_TO |
Date(10) |
DATE |
State date
|
| 21 |
EVENT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Event Type
Prompt Table:
FO_EVENT_DST_VW
|
| 22 |
ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
Prompt Table:
FO_ASGN_SR
|
| 23 |
SHOW_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Completed Agenda Items
Y/N Table Edit
Default Value: N
|
| 24 |
FO_EVENT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Search Type
A=All
AN=Agenda
AR=Agenda and Recruiting Funnel
AY=Recruiting Funnel
H=History
Default Value: A
|
| 25 |
EVENT_CATEGORY |
Character(10) |
VARCHAR2(10) NOT NULL |
Event Category
Prompt Table:
FO_CAT_SETUP_VW
|
| 26 |
ALL_TEAMS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include All Teams
A=Individual and Teams
T=Assigned under a Team
Y/N Table Edit
|