BUSINESS_UNITSO_IDSO_LINEMATCH_LINE_NBRPrompt Table: FO_CANDIDATE_VW
A=Applicant
E=Employee
Default Value: E
C=Considering
D=Declined
E=Accepted
O=Other
S=Assigned
N=No
Y=Yes
FO_SO_LINE_MTCH(SQL Table) |
Index Back |
|---|---|
Staffing Orders PeopleMatch |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 3 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 4 | MATCH_LINE_NBR |
Number(4,0) | SMALLINT NOT NULL | Match Line Number |
| 5 | 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_VW |
| 6 | CANDIDATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Candidate Type
A=Applicant E=Employee Default Value: E |
| 7 | OFFER_RESULT | Character(1) | VARCHAR2(1) NOT NULL |
Confidential Order
C=Considering D=Declined E=Accepted O=Other S=Assigned |
| 8 | FIT_SCORE_QUA | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | Qualifications Fit Score |
| 9 | FIT_SCORE_AVA | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | Availability Fit Score |
| 10 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 11 | FO_FUN_UCONS | Character(1) | VARCHAR2(1) NOT NULL |
Staffing Front Office Recruiting Funnel Under Consideration Field
N=No Y=Yes |