INSTALLATION_FO(SQL Table) |
Index Back |
|---|---|
Staffing Installation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESS_DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Employee Self Service Deptid
Prompt Table: DEPT_TBL |
| 2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department SetID
Prompt Table: SETID_TBL |
| 4 | ATTACH_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Attachment Type
Prompt Table: FO_ATTACH_TYPE |
| 5 | FO_USE_RS_CALENDAR | Character(1) | VARCHAR2(1) NOT NULL |
Add Assignments to Calendar
Y/N Table Edit Default Value: N |
| 6 | LAST_HIST_ID | Number(10,0) | DECIMAL(10) NOT NULL | Last History ID Assigned |
| 7 | FO_ADDL_JOBS_HRLY | Character(1) | VARCHAR2(1) NOT NULL |
Always Create New Jobs
Y/N Table Edit Default Value: N |
| 8 | FO_ADDL_JOBS_SLRY | Character(1) | VARCHAR2(1) NOT NULL |
Always Create New Jobs
Y/N Table Edit Default Value: N |
| 9 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL |
Task Category
Prompt Table: FO_TASK_TYPE_VW |
| 10 | FO_CHGSHIPTOWRK | Character(1) | VARCHAR2(1) NOT NULL | Change 'Ship-to' to 'Work' |
| 11 | ORG_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name
Prompt Table: PSDBFIELD |
| 12 | ORG_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Organization Unit Record
Prompt Table: PSRECDEFN |
| 13 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: TREE_NAME_VW |
| 14 | EMPL_ORG_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Search Scope Record
Prompt Table: PSRECDEFN |
| 15 | SYSTEM_EMAIL_ADDR | Character(254) | VARCHAR2(254) NOT NULL | System Email Address |
| 16 | FO_MAP | Character(254) | VARCHAR2(254) NOT NULL | View Map |
| 17 | FO_CHG_QUANTITY | Character(1) | VARCHAR2(1) NOT NULL |
Enable Resource Request Qty
Default Value: N |
| 18 | FO_ASSGN_CHG_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Enable Assigment Date Tracking
Default Value: N |
| 19 | FO_ALLOW_REOP | Character(1) | VARCHAR2(1) NOT NULL |
Reopening Assignments Setup Field
N=No Y=Yes Default Value: N |
| 20 | FO_ALLOW_ADDIT | Character(1) | VARCHAR2(1) NOT NULL |
Reopening Assignments Setup Field
N=No Y=Yes Default Value: N |
| 21 | LAST_PRCS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Last Process Instance |
| 22 | FO_RESUME_PARSING | Character(1) | VARCHAR2(1) NOT NULL |
Resume Parsing Provider
Y/N Table Edit |
| 23 | FO_OI_VENDOR_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Integration Vendor ID
Prompt Table: FO_VENDOR_VW |
| 24 | FO_PSFT_DOMAIN | Character(30) | VARCHAR2(30) NOT NULL |
PeopleSoft Domain
Prompt Table: FO_DOMAINS_VW |
| 25 | FO_JOBDIST | Character(1) | VARCHAR2(1) NOT NULL |
Job Board Distributor Provider
Y/N Table Edit |
| 26 | FO_JOBDIST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Job Board Distributor
Prompt Table: FO_VENDOR_VW |
| 27 | FO_APPLY_URL | Character(254) | VARCHAR2(254) NOT NULL | Staffing Apply Online URL |
| 28 | LANG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German INE=International English ITA=Italian JPN=Japanese POR=Portuguese |
| 29 | FO_AFTER_UPD_STS | Character(1) | VARCHAR2(1) NOT NULL |
After Update Status
A=Active P=Applicant Pending |
| 30 | FO_APPLY_REGIST | Character(1) | VARCHAR2(1) NOT NULL |
Candidate Registration
N=Registration Not Required O=Optional Registration R=Registration Required |
| 31 | FO_EXP_ASGN | Character(10) | VARCHAR2(10) NOT NULL |
Express Assignment Event
Prompt Table: FO_EVENTS_VW |
| 32 | FO_HIRE | Character(10) | VARCHAR2(10) NOT NULL |
Hire Event
Prompt Table: FO_EVENTS_VW |
| 33 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |
| 34 | FO_EMAIL_EVENT | Character(10) | VARCHAR2(10) NOT NULL |
Email event for history log
Prompt Table: FO_EVENTS_VW |