EP_INSTALLATION(SQL Table) |
Index Back |
|---|---|
ePerformance ManagementePerformance Management "Installation Table". This table allows you to configure global processing options for the ePerformance Management application module. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_LAST_APPR_ID | Number(8,0) | INTEGER NOT NULL | Last Appraisal Id assigned |
| 2 | EP_ALLOW_LANG_OVRD | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate whether review documents can be in languages other than the system base language. If set to YES, then an alternative language-code can be specified when creating a review.
Y/N Table Edit Default Value: N |
| 3 | EP_DEBUG_CALC_SW | Character(1) | VARCHAR2(1) NOT NULL |
Configuration Option - Enable rating calculation debugging
Y/N Table Edit Default Value: N |
| 4 | EP_NOTIFY_MGRDOC | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 5 | EP_NOTIFY_ROLEDOC | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 6 | EP_NOTIFY_EE_COMPL | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 7 | EP_NOTIFY_RQST_RWK | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 8 | EP_NOTIFY_RQST_RVW | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 9 | EP_NOTIFY_RQST_ACK | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 10 | EP_NOTIFY_EE_ACK | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 11 | EP_NOTIFY_DATE_CHG | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 12 | EP_NOTIFY_STS_CHG | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 13 | EP_NOTIFY_TRANSFER | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for events that occur during the life-cycle of a review.
Y/N Table Edit Default Value: Y |
| 14 | EP_BEGIN_DT_SW | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance Configuration switch -
Display Review Begin Date on Review Selection Page?
Y/N Table Edit Default Value: Y |
| 15 | EP_END_DT_SW | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance Configuration switch -
Display Review End Date on Review Selection Page?
Y/N Table Edit Default Value: Y |
| 16 | EP_REVIEW_STAT_SW | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance Configuration switch -
Display Review Status on Review Selection Page?
Y/N Table Edit Default Value: Y |
| 17 | EP_EMPL_JOB_SW | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance Configuration switch -
Display Employee Job Title on Review Selection Page?
Y/N Table Edit Default Value: Y |
| 18 | EP_MGR_NAME_SW | Character(1) | VARCHAR2(1) NOT NULL |
Display Manager Name
Y/N Table Edit Default Value: Y |
| 19 | EP_EMPLID_SW | Character(1) | VARCHAR2(1) NOT NULL |
Switch that determines if document header shows EmplID
Y/N Table Edit Default Value: N |
| 20 | EP_NOTIFY_BL_COMPL | Character(1) | VARCHAR2(1) NOT NULL |
Notify on Baseline complete
Y/N Table Edit Default Value: Y |
| 21 | EP_NOTIFY_BL_CREAT | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag
Y/N Table Edit Default Value: Y |
| 22 | EP_NOTIF_BL_REOPEN | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag
Y/N Table Edit Default Value: Y |
| 23 | EP_NOTIF_NM_SUBMIT | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag
Y/N Table Edit Default Value: Y |
| 24 | EP_NOTIF_NM_ACCEPT | Character(1) | VARCHAR2(1) NOT NULL |
Nominations Accepted
Y/N Table Edit Default Value: Y |
| 25 | EP_NOTIF_NM_CANCEL | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag
Y/N Table Edit Default Value: Y |
| 26 | EP_NOTIF_NM_DECLIN | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag
Y/N Table Edit Default Value: Y |
| 27 | EP_NOTIF_OTH_COMPL | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag
Y/N Table Edit Default Value: Y |
| 28 | EP_NOTIF_MGR_COMPL | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag
Y/N Table Edit Default Value: Y |
| 29 | EP_NOTIF_EVL_CANCL | Character(1) | VARCHAR2(1) NOT NULL |
Notify on Cancel Evaluation
Y/N Table Edit Default Value: Y |
| 30 | EP_NOTIF_DOC_CANCL | Character(1) | VARCHAR2(1) NOT NULL |
Notification flag for Cancel Document
Y/N Table Edit Default Value: Y |
| 31 | EP_NOTIF_BASE_ERR | Character(1) | VARCHAR2(1) NOT NULL |
Baseline Creation Error
Default Value: Y |
| 32 | EP_NOTIF_EMP_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Y/N switch to notify the Manager when an Employee adds an item to the Establish Criteria document
Y/N Table Edit Default Value: Y |
| 33 | EP_NOTIF_MGR_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Y/N switch to notify the Employee when a Manager adds an item to the Establish Criteria document
Y/N Table Edit Default Value: Y |
| 34 | EP_PSAUDIT_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Y/N field to specify whether or not the customer is using the PS Audit for ePerformance Item changes
Y/N Table Edit Default Value: N |
| 35 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |
| 36 | EPO_LAST_PAGE_ID | Number(8,0) | INTEGER NOT NULL | Keeps track of the last Objective Page Id that was assigned |
| 37 | EPO_LAST_OBJITM_ID | Number(12,0) | DECIMAL(12) NOT NULL | Objectives Management: Objective Page last ObjectItem ID field |
| 38 | EPO_NOTIF_PAGE_CR | Character(1) | VARCHAR2(1) NOT NULL |
Notify owner when Objectives Page is created
Y/N Table Edit Default Value: Y |
| 39 | EPO_NOTIF_TRFRNEW | Character(1) | VARCHAR2(1) NOT NULL |
Notify the new owner when an Objective page is transfered
Y/N Table Edit Default Value: Y |
| 40 | EPO_NOTIF_TRFROLD | Character(1) | VARCHAR2(1) NOT NULL |
Notify the old owner when an Objective page is transfered
Y/N Table Edit Default Value: Y |
| 41 | EPO_NOTIF_SUBMIT | Character(1) | VARCHAR2(1) NOT NULL |
Notify the Admin when an Objective page is submitted for publication
Y/N Table Edit Default Value: Y |
| 42 | EPO_NOTIF_PUB_OWN | Character(1) | VARCHAR2(1) NOT NULL |
Notify recipients when Objective Page is Published to Page Owners
Y/N Table Edit Default Value: Y |
| 43 | EPO_NOTIF_OWN_ONE | Character(1) | VARCHAR2(1) NOT NULL |
Only one notification when Objective Page is Published to Page Owners
Default Value: Y |
| 44 | EPO_NOTIF_PUB_EMP | Character(1) | VARCHAR2(1) NOT NULL |
Notify recipients when Objective Page is Published to employees
Y/N Table Edit Default Value: Y |
| 45 | EPO_NOTIF_EMP_ONE | Character(1) | VARCHAR2(1) NOT NULL |
Only one Notification to recipients when Objective Page is Published to employees
Default Value: Y |
| 46 | EPO_NOTIF_CASC_EE | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for cascade objective items.
Y/N Table Edit Default Value: N |
| 47 | EPO_NOTIF_CASC_MGR | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for cascade objective items.
Y/N Table Edit Default Value: N |
| 48 | EPO_NOTIF_FIRSTPUB | Character(1) | VARCHAR2(1) NOT NULL |
Only notify when the objective page is published for the first time, no subsequent publications.
Y/N Table Edit Default Value: Y |
| 49 | EP_EODI_PNOTES_SW | Character(1) | VARCHAR2(1) NOT NULL |
Performance Notes Integration
Y/N Table Edit Default Value: N |
| 50 | EP_EODI_TASKS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Task Integration
Y/N Table Edit Default Value: N |
| 51 | EP_TSK_REMIND_DAYS | Number(3,0) | SMALLINT NOT NULL | Task Remind Days |
| 52 | EP_NOTIF_EC_APV | Character(1) | VARCHAR2(1) NOT NULL |
Evaluation Criteria is Approved
Y/N Table Edit Default Value: Y |
| 53 | EP_NOTIF_TP_SHARE | Character(1) | VARCHAR2(1) NOT NULL |
Track Progress Comments are shared.
Y/N Table Edit Default Value: Y |
| 54 | EP_NOTIF_CP_COMPL | Character(1) | VARCHAR2(1) NOT NULL |
Progress Check Point is completed
Y/N Table Edit Default Value: Y |
| 55 | EP_NOTIF_TP_REOPEN | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag
Y/N Table Edit Default Value: Y |
| 56 | EP_NOTIF_CHKPT_SKP | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag
Y/N Table Edit Default Value: Y |
| 57 | EP_CANCEL_TERM_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if performance/development documents should be cancelled when EE gets terminated.
Y/N Table Edit Default Value: N |
| 58 | EP_CANC_DOCTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Used to deteremine whether all docment types or selected doc types to be cancelled.
A=All Document Types S=Selected Document Types Default Value: A |
| 59 | EP_AUTOSAVE_SW | Character(1) | VARCHAR2(1) NOT NULL |
field on the Installation table to enable AutoSave
Y/N Table Edit Default Value: N |
| 60 | EP_NOTIF_CP_REOPEN | Character(1) | VARCHAR2(1) NOT NULL |
ePerformance notify flag - Checkpoint Reopen
Y/N Table Edit Default Value: Y |
| 61 | EP_DISABLE_RTE_SW | Character(1) | VARCHAR2(1) NOT NULL |
field on the Installation table to enable RTE on the main document page
Y/N Table Edit Default Value: N |
| 62 | EP_ANCHOR_SAVE_SW | Character(1) | VARCHAR2(1) NOT NULL |
field on the Installation table to allow cursor position to remain in place when document is saved instead of scrolling to top of page.
This will help users keep their place in long documents
Y/N Table Edit Default Value: N |
| 63 | EP_REMIND_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Enable ePerfomance Due Date Notifications
Y/N Table Edit Default Value: N |
| 64 | EP_REMIND_SCHED_DT | DateTime(26) | TIMESTAMP | ePerformance Notifications - Specifies the date and time the schedule was last created. |
| 65 | EP_AUTO_XFER_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if performance/development documents should be transferred when EE gets terminated.
Y/N Table Edit Default Value: N |
| 66 | ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Access Type
1=By Dept Security Tree 2=By Supervisor ID 3=By Department Manager ID 4=By Reports To Position 5=By Part Posn Mgmt Supervisor 6=By Part Posn Mgmt Dept Mgr ID 7=By Group ID |
| 67 | EP_XFER_MGR_DOCTYP | Character(1) | VARCHAR2(1) NOT NULL |
Used to deteremine whether all docment types or selected doc types will be used to transfer managers documents
A=All Document Types S=Selected Document Types Default Value: A |
| 68 | EP_AUTO_XFER_EE_SW | Character(1) | VARCHAR2(1) NOT NULL | Yes/No switch used to determine if performance/development documents should be transferred when EE gets transferred. |
| 69 | EP_XFER_EE_DOCTYP | Character(1) | VARCHAR2(1) NOT NULL |
Used to deteremine whether all docment types or selected doc types will be used to transfer employees documents
A=All Document Types S=Selected Document Types |
| 70 | EP_DAYS_TO_END | Number(3,0) | SMALLINT NOT NULL | Number of Days until Period End Date. Used for Auto Transfer when EE changes jobs. |
| 71 | EP_ADD_MGR_PEER_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No, Add the manager as a participant.
Used for Auto Transfer when EE changes jobs.
Y/N Table Edit Default Value: N |
| 72 | EP_XFER_AFT_END_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No, transfer documents after their period end dates.
Used for Auto Transfer when EE changes jobs.
Y/N Table Edit Default Value: N |
| 73 | EPO_ALLOW_CREATE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Create Documents
Y/N Table Edit Default Value: N |
| 74 | EPO_ALLOW_PUBLISH | Character(1) | VARCHAR2(1) NOT NULL |
Allow Manager to Publish
Y/N Table Edit Default Value: N |
| 75 | EPO_ALLOW_CASCADE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Manager to Cascade Items
Y/N Table Edit Default Value: N |
| 76 | EPO_ALLOW_SEL_OWN | Character(1) | VARCHAR2(1) NOT NULL |
Allow alternate editor to select owner
Y/N Table Edit Default Value: N |
| 77 | EPO_NOTIF_PUB_ADM | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification to Admin for publish of objective items by a manager.
Y/N Table Edit Default Value: N |
| 78 | EPO_NOTIF_CASC_ADM | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification to Admin for cascade of objective items by a manager.
Y/N Table Edit Default Value: N |
| 79 | EP_RTE_IN_FLUID_SW | Character(1) | VARCHAR2(1) NOT NULL |
Switch field for indicating if we should display Rich Text Edit fields in Fluid ePerformance
L=Long Edit Box Only R=Use Rich Text Edit Default Value: R |