FO_AGN_HST_VW

(SQL View)
 Index Back

SELECT AG.AGENDA_ID , 0 , AG.OPRID , AG.USERID , AG.START_DATE , AG.END_DATE , AG.EVENT_TYPE , AG.AGENDA_PRIORITY , AG.FO_EVENT_STAT , AG.OWNERSHIP_ID , AG.BUSINESS_UNIT , AG.FO_DATE , AG.FO_RF_EVENT , AG.LASTUPDOPRID , AG.CUSTOMER_SETID , AG.CUST_ID , AG.CONTACT_SETID , AG.CONTACT_ID , AG.CANDIDATE_TYPE , AG.CANDIDATE_ID , AG.SO_ID , AG.SO_LINE , AG.ASSIGNMENT_ID , AG.FO_SUBEVENT , 'A' || AG.FO_RF_EVENT , AG.COMPLETED , AG.FO_PROC_EVNT_ST , 'AG' , AG.CONTACT_METHOD FROM PS_FO_AGENDA_DTL AG UNION ALL SELECT 0 , HS.HISTORY_ID , HS.OPRID , HS.USERID , HS.START_DATE , HS.END_DATE , HS.EVENT_TYPE , HS.AGENDA_PRIORITY , HS.FO_EVENT_STAT , HS.OWNERSHIP_ID , HS.BUSINESS_UNIT , HS.FO_DATE , 'N' , HS.LASTUPDOPRID , HS.CUSTOMER_SETID , HS.CUST_ID , HS.CONTACT_SETID , HS.CONTACT_ID , HS.CANDIDATE_TYPE , HS.CANDIDATE_ID , HS.SO_ID , HS.SO_LINE , HS.ASSIGNMENT_ID , HS.FO_SUBEVENT , 'H' , 'O' , HS.FO_PROC_EVNT_ST , 'HS' , HS.CONTACT_METHOD FROM PS_FO_HISTORY HS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AGENDA_ID Number(15,0) DECIMAL(15) NOT NULL Agenda ID
2 HISTORY_ID Number(15,0) DECIMAL(15) NOT NULL History ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
5 START_DATE Date(10) DATE Start Date for Gen Standing PO
6 END_DATE Date(10) DATE End Date
7 EVENT_TYPE Character(10) VARCHAR2(10) NOT NULL Event Type
8 AGENDA_PRIORITY Character(4) VARCHAR2(4) NOT NULL Agenda Priority
1=High
2=Medium
3=Low
9 FO_EVENT_STAT Character(1) VARCHAR2(1) NOT NULL Staffing Front Office Recruiting Funnel Event Status
C=Completed
I=In Progress
O=Pending
P=Partially complete
10 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 FO_DATE Date(10) DATE Date
13 FO_RF_EVENT Character(1) VARCHAR2(1) NOT NULL Recruting Flag Evnet

Y/N Table Edit

14 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.
15 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
16 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.
17 CONTACT_SETID Character(5) VARCHAR2(5) NOT NULL Contact SetID
18 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
19 CANDIDATE_TYPE Character(1) VARCHAR2(1) NOT NULL Candidate Type
A=Applicant
E=Employee
20 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.
21 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
22 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
23 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
24 FO_SUBEVENT Character(10) VARCHAR2(10) NOT NULL Staffing Front Office Recruiting Funnel SubEvent

Prompt Table: FO_SBEVT_VW

25 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
26 COMPLETED Character(1) VARCHAR2(1) NOT NULL Completed

Y/N Table Edit

27 FO_PROC_EVNT_ST Character(1) VARCHAR2(1) NOT NULL Staffing Front Office Recruiting Funnel Process Event Status
C=Completed
I=In Progress
O=Pending
28 TYPE_ADD Character(3) VARCHAR2(3) NOT NULL Trans Type - Add
29 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