HISTORY_IDDefault Value: 999999999999999
Prompt Table: SP_BU_PC_NONVW
Prompt Table: FO_ORDR_SRCH_VW
Prompt Table: FO_EVENT_DST_VW
A=Applicant
E=Employee
C=Considering
D=Declined
E=Accepted
O=Other
S=Assigned
FO_CAND_HISTORY(SQL View) |
Index Back |
|---|---|
Front Office HistoryAll Front Office History Data |
| SELECT HISTORY_ID , BUSINESS_UNIT , SO_ID , EVENT_TYPE ,CANDIDATE_TYPE ,CANDIDATE_ID , OFFER_RESULT , DATETIME_ADDED , COMMENTS_2000 FROM %Table(FO_HISTORY) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HISTORY_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
History ID
Default Value: 999999999999999 |
| 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
Prompt Table: FO_ORDR_SRCH_VW |
| 4 | EVENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Event Type
Prompt Table: FO_EVENT_DST_VW |
| 5 | CANDIDATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Candidate Type
A=Applicant E=Employee |
| 6 | 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. |
| 7 | OFFER_RESULT | Character(1) | VARCHAR2(1) NOT NULL |
Confidential Order
C=Considering D=Declined E=Accepted O=Other S=Assigned |
| 8 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 9 | COMMENTS_2000 | Long Character | CLOB | Comment Text |