Peoplesoft Tables

Profile Management

Table Name Description Long Description Parent Record
PS_RUN_JPM_CLONE Profile Type Clone Run Ctl
PS_JPM_JP_ACTION_L Profile Actions Related Lang
PS_JPM_JP_ACTIONS Profile Action Configuration
PS_RUNCTL_JPM_DR JPM Supervisor Unload RunCtl JPM Direct Reports Supervisor Unload run control
PS_RUNCTL_JPM_GRP Profile Group Build Process RC Run Control for the Profile Group Build Process.
PS_JPMINSTALLATION JPM Installation Table Stores JPM-specific installation data
PS_JPM_CAT_GMEMB JPM Catalog Item Group Member JPM Catalog Item Group Membership
PS_JPM_CAT_GROUPS Catalog Groups – Talent Mgmt
PS_JPM_CAT_GTYPE Catalog Group Types JPM_CT_NOHOC_VW
PS_JPM_CAT_ITEMS Catalog Items – Talent Mgmt Defines all of the Catalog Items for a particular Catalog Type.   Important-   All fields that are property fields yet not contained in the property subrecords (required properties) must exist before the property subrecords. All fields that are not properties but need to be fields in the record should be after the properties subrecord/s.   Any field placed before the properties subrecords will become required properties for catalog types. JPM_CAT_TYPES
PS_JPM_CAT_ITEM_RD Cat Item Rating Descriptions Catalog Item Rating Descriptions. This table permits alternate rating descriptions for each rating for each catalog item. JPM_CAT_ITEMS
PS_JPM_CAT_I_RLAT Catalog Relationships Talent Mgmt – Defines relationship between Catalog Items. JPM_CAT_ITEMS
PS_JPM_CAT_PROPS Talent Mgmt – Type Properties Catalog Type Properties. Defines which attributes of a Catalog pertain to a particular Catalog Type. JPM_CAT_TYPES
PS_JPM_CAT_TYPES Catalog Types – Talent Mgmt This table defines the different TYPES of Talent Management catalogs.
PS_JPM_CAT_T_RLAT Cat Type Relationships Relationship defintions for a Content Type
PS_JPM_C_LIST_DEFN JPM Cust List Value Definition Defines a Custom List that can be used in conjunction with a field in the Content Type table.
PS_JPM_C_LIST_ITEM JPM Custom List Item Value The specific List Items for the dropdown list for a field a defined in a Content Type JPM_C_LIST_DEFN
PS_JPM_GMEMB_BKUP JPM Profile Group Members Backup of Profile Group Member table for Job Profile Management by group. Used by group build program.
PS_JPM_GRP_FILTER Group Build Filter Criteria The criter used to build a group defined from the Profile Group Page. JPM_JP_GROUPS
PS_JPM_GRP_RES_TBL
PS_JPM_IDX_UPDCTL Verity Index Triggers
PS_JPM_INTEREST Interest List Contains profiles that people are interested in PERSON
PS_JPM_ITMRPT_RCTL JPM JPM
PS_JPM_JPPRPT_RCTL JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_JPRPT_RCTL JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_JPXCPT_RCTL JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_JP_CAT_TYPE Catalog Types in Profile Catalog Types in Profile
PS_JPM_JP_FILTERS
PS_JPM_JP_GMEMB JPM Profile Group Members Profile Group Member table for Job Profile Management. Contains the profile IDs of profile that belong to the group.
PS_JPM_JP_GROUPS JPM Profile Groups Profile Groups Record. Parent table to store profile group details for groups of Profiles within Job Profile Management
PS_JPM_JP_GTYPE Profile Group Types JPM Profile Group Types. Contains details about the Profile Group Type for JPM.
PS_JPM_JP_GTYP_MBR JPM Profile Group Types Stores JPM Profile Types within a Profile Group Type.
PS_JPM_JP_ITEMS JPM Profile Items Defines the Profile Content Items for a particular Profile. JPM_PROFILE
PS_JPM_JP_PRI_TYPE Primary Profile Type Table Contains the Primary person and non-person profile types for products   interfacing to JPM
PS_JPM_JP_PROPS Talent Mgmt – Type Properties Profile Type Properties. Defines which additional attributes of a Catalog Item pertain to a particular Catalog Type, within the context of a Job Profile.. JPM_JP_SECTION
PS_JPM_JP_QUAL_INS JPM Instance Qualifiers JPM Instance Qualifiers
PS_JPM_JP_QUAL_SET JPM Instance Qualifier Set JPM Instance Qualifiers Sets
PS_JPM_JP_ROLES Profile Attributes
PS_JPM_JP_SECTION Profile Attributes Profile Attributes JPM_JP_TYPES
PS_JPM_JP_SYND_SRC jpm jpm
PS_JPM_JP_TAB Profile Type Content Tabs
PS_JPM_JP_TYPES Profile Types – Talent Mgmt This table defines the different TYPES of Talent Management Job Profiles.
PS_JPM_JP_TYP_PAOS Profile Type Associations
PS_JPM_JP_TYP_PIDS Profile Identity Options JPM Profile Identity Option definitions
PS_JPM_JP_WF_HDR Profile Approval Header Profile Approval Transaction Header record.
PS_JPM_JP_WF_ITEMS Catalog Items – Talent Mgmt Defines all of the Catalog Items for a particular Catalog Type
PS_JPM_JP_WF_XRLAT Profile Identities for Apprval Profile External Relationship updates that have been saved pending Approval. JPM_PROFILE
PS_JPM_JP_X_RLAT Profile External Relationships Effective Date of a set of Profile External Relationships. We must track External Relationships as an Effectived-Dated GROUP because we allow multiple entries for a single Relationship Name to be in effect concurrently. JPM_PROFILE
PS_JPM_NPRPT1_RCTL JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_NPRPT2_RCTL JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_NPRPT_RCTL JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_OPNAPR_XREF JPM Profile Approval Xref Cross Reference table for Profile Approvals
PS_JPM_PKG_TYPES Custom Packages This table defines the custom application packages and classes used in   to control UI and Data Validation for Content Items and Profile Items. the custom packages extends the property attributes.
PS_JPM_PPRPT1_RCTL JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_PPRPT2_RCTL JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_PPRPT_RCTL JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_PROFILE JPM Profile Header Stores the profile ID and other header information for a profile.
PS_JPM_PROFILE_WRK Profile Selection List This table is used in Person Profile components for the “Copy from Job Profile” action. It is loaded with a list of related profiles that the user may select from.   The rdata is not saved.
PS_JPM_RLAT_CFG Profile Identity Option Cfg
PS_JPM_RLAT_SEL Avail Profile Identity Options
PS_JPM_RLAT_SEL_LN
PS_JPM_RPT1_RCTL JPM JPM
PS_JPM_SRCH_CFG JPM Search Configuration
PS_JPM_SRCH_CTYPE JPM Search Catalog Types
PS_JPM_SRCH_ITEMS JPM Search Catalog Items Searchable Catalog Items for a particular Catalog Type
PS_JPM_SRCH_ROLE JPM Search Configuration Defines the roles that apply to a search configuration instance. JPM_SRCH_CFG
PS_JPM_SRCH_RUN JPM Search Indx Run Ctl rec JPM Profile Verity index build process run control record
PS_JPM_SUPERVISORS Supervisor List Flat list of “Supervisors” for a particular EMPLID/EMPL_RCD instance. This is created by a batch AE process.
PS_UC_JPM_JP_ITEMS UC Workforce Dev Conversion RCASTRO 7/20/2010 – Worforce Development Conversion – JPM
PS_JPM_UPG_RCTL JPM Upgrade Run Control

ePerformance

TABLE_NAME Description Long Description Parent Record
PS_EP_A_STA_HST Wkflw for Appraisal SS Archive This record is a child of EP_APPR and is used to store data about each step of the workflow approval process for a Performance Document Approvalrequest.
PS_EP_CHK_SUG_TBL Language Suggestion Table Record used to store language suggestions used in the Language Word/Phrase Checker
PS_EP_CHK_WRD_TBL Language Checker Table Record used to store language words/phrases used in the Language Word/Phrase Checker
PS_EP_COMP_DEV_TBL Competency Development Tip Competency Development Tips – Used to provide helpful tips for a level of proficiency for a competency. These tips are designed to further enhance or improve a competency. CM_RATING_DESCR
PS_EP_COMP_WRT_TBL Competency Results Writer Record used to store the competency results writer text CM_RATING_DESCR
PS_EP_CR_APPR_AET A generic cache record for eP A generic cache record for ePerformance Mgmt
PS_EP_DEBUG_DTL Calculation Debug Details This table is used to store the output of the ePerformance Rating Calculation Debugger.
PS_EP_DESIRED_DIST Desired Distribution Table Desired Rating Distribution Table
PS_EP_DES_DIST_PCT Desired Rating Distribution % Desired Rating Distribution Percentages EP_DESIRED_DIST
PS_EP_DEV_TIP_TBL Development Tips Table Record used to store development tips
PS_EP_EE_RES_TBL Batch Review Creation Results Result table used during the batch creation of Reviews.
PS_EP_GRP_RES_TBL Batch Review Creation Results Result table used during Group Build and the batch creation of Reviews.
PS_EP_INSTALLATION ePerformance Management ePerformance Management “Installation Table”. This table allows you to configure global processing options for the ePerformance Management application module.
PS_EP_LC_MATCHES Lang Checker – Matches Table This table contains the matches in an Employee Review found by the Language Checker. This table is only used as temporary local rowset in the Employee Review. The table never stores any rows in the database.
PS_EP_LM_LEARNING ePerformance Learning This is empty record for Learning
PS_EP_PERF_NOTES Performance Notes This record is used to hold performance notes related to a particular employee.
PS_EP_PE_OPR_A_DYS EE Review Alerts – Opr Prefs Stores personalizations relating to the Employee Review Alerts pagelet.
PS_EP_PE_OPR_A_STP EE Review Alerts – Opr Prefs Stores personalizations relating to the Employee Review Alerts pagelet.
PS_EP_RATING_LIST Rating List Temp Table This is a temporary table to store labels for the ratings radio buttons.
PS_EP_APPR Document Header
PS_EP_REVW_TYP_TBL Document Type: Setup Document Type: Setup – Used to create/update document types.
PS_EP_APPR_B_ITEM Document Item – Baseline EP_APPR_B_SEC
PS_EP_TMPL_ITEM Template Item: Setup EP_TMPL_SECTION
PS_EP_ROLE_TBL ePerformance Roles: Setup ePerformance Roles: Setup – Used to create/update roles used in ePerformance transactions.
PS_EP_RPT_DIST_SUM Rating Distribution Summary Rating Distribution Chart is based on this data.
PS_EP_RPT_EXTR_AET Report Snapshot State Rec State record for Report Snapshot App Engine process
PS_EP_RPT_GPBLD Group Build Result Set Group Build Result set used for reporting.
PS_EP_RPT_SNAP_DTL Report Snapshot Dtl Rec Stores detail review information extracted during the Report Snapshot Summary process. The drill-down for the Status Summary and Rating Distribution charts is references this data.
PS_EP_APPR_ITEM Document Item EP_APPR_SECTION
PS_EP_RPT_STS_SUM Basis for Status Summary Chart Provides data for Status Summary pie chart.
PS_EP_RPT_SUM_HDR Header Record for Charts List summary information for Status Summary and Rating Distribution charts.
PS_EP_SECTION_DEFN Section: Setup Section: Setup – Used to create/update the rules for a document section.
PS_EPO_CASCADE_AET Cascade Items State Rec State Record of cascade batch process
PS_EP_SUB_DEV_TBL Sub-Competency Development Tip Sub-Competency Development Tips – Used to provide helpful tips for a level of proficiency for a sub-competency. These tips are designed to further enhance or improve a sub-competency. EP_SUB_PROF_TBL
PS_EP_SUB_WRT_TBL Sub-Competency Results Writer Sub-Competency Results Writer – Used as writing helper when updating the results in a performance review. Uses various character identifiers to pass gender specific pronouns to tailor the sentences to an individual. EP_SUB_PROF_TBL
PS_EP_TMPL_DEFN Template Header: Setup Template Header: Setup – Used to create/update document template definitions.
PS_EP_TMPL_PARTIC Template Participation: Setup Template Participation: Setup – Used to create/update document template participation roles. EP_TMPL_DEFN
PS_EP_TMPL_ROLE Template Section Role: Setup Template Section Role: Setup – Used to create/update template section roles. EP_TMPL_SECTION
PS_EP_TMPL_ROLE_EC Template Section Role: Setup Template Section Role: Setup – Used to create/update template section roles. EP_TMPL_SECTION
PS_EP_TMPL_SECTION Template Section: Setup Template Section: Setup – Used to create/update template section rules. EP_TMPL_DEFN
PS_EP_TMPL_SUBITEM Template Sub-Items: Setup Template Sub-Items: Setup – Used to create/update template sub-items. EP_TMPL_ITEM
PS_EP_WT_RESULTS Writing Tools Results Record This record is used to consolidate the real time results from the four different writing tools into a suggested results page. This table never holds any data, but must be created as a table for certain peoplecode to function properly.   This table is also referenced on each of the advanced search pages within the writing tools, and performs the same job of consolidating the results.
PS_EPO_CASC_REP Cascade Items Report Table Temporary table used for reporting
PS_EPO_CASC_ROLE Cascade Items to Doc’s role Cascade items in the Performance Documents of all the Roles
PS_EPO_METRICS_AET epo data extrct state table State Record for AE data extract for online report.
PS_EPO_NODES Objectives used for notificati Used as a rowset to hold all Nodes that report (Dept or Position) to the Published node. Used in Notification process when a page gets published.
PS_EPO_NOTIFY_AET Obj Notify state record State record used by the Objectives Notify AE program, EPO_NOTIFY.   The AE is called from the Publish Objectives Pages component to generate email notifications in batch mode.
PS_EPO_OBJ_EXTRACT epo summary data table Stores the data for the online report ‘Employees Aligned to Objectives’
PS_EPO_OBJ_PLAN Objective Plan Table Objective Plan information table
PS_EPO_OBJ_RUNCTL Objectives Run Control Run Control record for generating Business Objectives Summary data.
PS_EPO_OC_NODE_WR2 Structure Work Record This is a work record used for ‘Identify Nodes’ component to select the nodes in the grid. Holds information from record HR_OC_STRUCT_WK.
PS_EPO_OC_NODE_WRK Structure Work Record This is a work record used for ‘Identify Nodes’ component to select the nodes in the grid. Holds information from record HR_OC_STRUCT_WK.
PS_EPO_PG_HDR Obj Page Header Record Objectives Management Header record for the Objectives Page
PS_EPO_PG_ITEM Objectives Page Item Holds the Item information for the Objectives Pages EPO_PG_SECTION
PS_EPO_PG_SECTION Objectives Page Section Sections on the Objectives Page EPO_PG_HDR
PS_EPO_PG_SUBITEM Objectives Page Sub Item Objectives Management: Holds the Sub Item information for the Objectives Pages EPO_PG_ITEM
PS_EPO_PLAN_DEPT Objective Plan – Setids This table holds the Setids for the Objective Plan. Only used when the Objective Plan is defined using a Department Hierarchy.
PS_EPO_PLAN_PAGES Objective Plan – Node Relation Store list of all nodes of a tree(hierarchy method is defined on Objective Plan) that are associated with an Objective Page for a plan.     Tree will be either manual using Tree-Manager or created from transactional data.
PS_EPO_PUBNODE_TMP Temp table for Published Nodes Temporary table of Published Nodes used by the AE program for Batch Notifications
PS_EPO_SECTN_DEFN Objective Page Sections Section definition for Objective Pages
PS_EPO_SELECT_DEPT Obj Page Creation This record, although defined as a physical record, will be used as a derived record to hold the departments used in the creation process.
PS_EPO_SELECT_POSN Obj page Creation This record, although defined as a physical record, will be used as a derived record to hold the positions used in the creation process.
PS_EPO_SYND_AET Sydicate state record State record used by the Objectives Syndicate AE program, EPO_SYNDICATE. The AE is called from the Publish Objectives Page component to update items in the Performance Document when an Objective page is Re-Published after modifications to its items.
PS_EPO_SYND_PG_TMP Objective Pages to be Syndicat Temporary table populated when Objective Pages get Re-Published. The table is used by the Syndication process.   The Syndication process will remove rows when Syndication is complete.
PS_EPO_TMPL_DEFN Objective Template: Setup Template Header: Setup – Used to create/update objective page template definitions.
PS_EPO_TMPL_SECTN Objective Template Section Sections defined in the template of an Objective Page EPO_TMPL_DEFN
PS_EPS_MRKT_CD_TBL EPS Market Code record This records contains the description for the ‘EPS Market Code’ field.   Currently, this data is manually entered.
PS_EPS_MSGS EPS Processing Messages Contains the messages from the EPS processing programs.
PS_EPS_ORG_CD_TEMP
PS_EPS_ORG_PARMS Run Control EPS Assign Org This record contains the parameters for the EPS Asign Organization Process.
PS_EPS_PARMS Parms for EPS processes This record contains the parameters for the EPS background processes.
PS_EPS_SUSP_DATA EPS Suspense Record This record contains those EPS data rows which had some type of problem encountered while loading into the EPS setup table. Corrections to data in this table are manual corrections to the setup table.
PS_EPS_SUSP_TEMP Temp Table Used for EPS Load This is a temporary table used for loading new EPS entities.
PS_EPS_ZIPMRKT_TBL EPS Zip to Market record This table contains the ‘Zip To Market’ data from EPS.
PS_EP_ALERT_DAYS EE Review Alerts Days This record determines when alerts appear for each Review Type on the Employee Review Alerts pagelet.
PS_EP_ALERT_SETUP EE Review Alerts Setup Stores setup and defaults relating to the Employee Review Alerts pagelet.
PS_EP_APPR_B_ROLE Document Role – Baseline Document Role – Baseline EP_APPR_B_SEC
PS_EP_APPR_B_SEC Document Section – Baseline Document Section – Baseline EP_APPR
PS_EP_APPR_B_SUB Document Sub-Item – Baseline Document Sub-Item – Baseline EP_APPR_B_ITEM
PS_EP_APPR_HST Document Header Archive
PS_EP_APPR_NOMINEE Nominate Participants This record is used to hold list of nominees which have been submitted as participants for a review. This record is used during the Track Nominations process. EP_APPR
PS_EP_APPR_NOM_LST Building Rvw Participant List This record is used to select employee’s who will participate in the review process. EP_APPR
PS_EP_APPR_PARTIC Document Participants EP_APPR
PS_EP_APPR_ROLE Document Role ePerformance table used to store Evaluation Role information. EP_APPR
PS_EP_APPR_SECTION Document Section ePerformance table used to store Evaluation Section information. EP_APPR_ROLE
PS_EP_APPR_STA Wkflow for Appraisal SS This record is a child of EP_APPR and is used to store data about each step of the workflow approval process for a Performance Document Approvalrequest.
PS_EP_APPR_SUBITEM Document Sub-Item ePerformance table used to store Evaluation Sub-Item information. EP_APPR_ITEM
PS_EP_APPR_XREF ePerformance AWE Cross Ref Rec
PS_EP_AP_ITM_TMP Document Item Temp Table Used when copying items from one role appraisal to another role appraisal.
PS_EP_ATTACH ePerformance Attachments This record contains ePerformance document attachments
PS_EP_AP_SEC_TMP Document Section Temp Table Used when copying sections from one role appraisal to another role appraisal.
PS_EP_ATTACH_HST ePerf attachment archive
PS_EP_AP_SUB_TMP Document Subitem Temp Tbl Used when copying subitems from one role appraisal to another role appraisal.
PS_EP_A_B_ITEM_HST Doc Item – Baseline Archive Document Item – Baseline EP_APPR_B_SEC
PS_EP_A_B_ROLE_HST Doc Role – Baseline Archive Document Role – Baseline EP_APPR_B_SEC
PS_EP_A_B_SEC_HST Doc Section – Baseline Archive Document Section – Baseline EP_APPR
PS_EP_A_B_SUB_HST Doc Sub-Item – Bseline Archive Document Sub-Item – Baseline EP_APPR_B_ITEM
PS_EP_A_ITEM_HST Document Item Archive ePerformance table used to store Evaluation Item information. EP_APPR_SECTION
PS_EP_A_NM_LST_HST Bldg Rvw Prtcpnt List Archive This record is used to select employee’s who will participate in the review process. EP_APPR
PS_EP_A_NOMINE_HST Nominate Participants Archive This record is used to hold list of nominees which have been submitted as participants for a review. This record is used during the Track Nominations process. EP_APPR
PS_EP_A_PARTIC_HST Document Participants Archive EP_APPR
PS_EP_A_ROLE_HST Document Role Archive ePerformance table used to store Evaluation Role information. EP_APPR
PS_EP_A_SBITM_HST Document Sub-Item Archive ePerformance table used to store Evaluation Sub-Item information. EP_APPR_ITEM
PS_EP_A_SECTN_HST Document Section Archive ePerformance table used to store Evaluation Section information. EP_APPR_ROLE

AWE

Table Name DescriptIon Long Description Parent Record
PS_EOAWCRTA Criteria Definition Criteria used primerily for Approvals.
PS_EOAWCRTA_REC Criteria Definition Criteria can be defined as queries, application classes & SQL Definitions.
PS_EOAWCRTA_VAL User List Definition Maps User List to sources or user list data e.g. roles, queries, application classes & SQL Definitions.
PS_EOAWEMC_LYT_HDR Form Layout Definitions Header
PS_EOAWEMC_LYT_LIN Form Layout Definitions Line EOAWEMC_LYT_HDR
PS_EOAWEMC_MSGHDR
PS_EOAWEMC_PND_HDR Pending Collaborative Emails This table keeps a record of collaborative emails that have been sent out and are awaiting a response.
PS_EOAWEMC_PND_LIN Collaborative Emails Pending This table tracks collaborative emails that have been sent out and are awaiting a response. It keeps a record of every field the implementing application put into the message definition, and it’s associated HTML Field Name so that the data can be mapped back in when the response arrives. EOAWEMC_PND_HDR
PS_EOAWEMC_SPM_LOG EMC Spam Log This record tracks emails that are received into the EMC mailbox and do not correlate with any EMC state table rows.
PS_EOAWFIELD_LIST Field List Definition Utilitarian field list. Used initially with Workflow Approvals to identify whether important fields change so that Approvals can be re-submitted.
PS_EOAWFRMINPT_HDR
PS_EOAWFRMINPT_LIN EOAWFRMINPT_HDR
PS_EOAWNEM Main record for NEM Main record for NEM
PS_EOAWNEM_AET State Record State Record
PS_EOAWNEM_EMAIL
PS_EOAWNEM_EVENTS Event Table for the SACNEM
PS_EOAWNEM_RQST Run Cntrl record Run Cntrl record
PS_EOAWNEM_STATUS NEM Status NEM Status
PS_EOAWUSER_LIST User List Definition Maps User List to sources or user list data e.g. roles, queries, application classes & SQL Definitions.
PS_EOAWXLAT_SYMBOL
PS_EOAW_ADMMON_CFG
PS_EOAW_ADT_AET AWE Audit Report Run control record for the AWE Audit Report
PS_EOAW_APPR_ARC
PS_EOAW_AUTH
PS_EOAW_AUTH_DTL Authorization Detail Authorization Detail for Approvals
PS_EOAW_DECISION Mass Approvals Action Table Contains an action that is to be taken in the Mass Approvals Framework.     The record is update upon completion of the action taken.
PS_EOAW_IDS SAC_AW Id counters Counters for Approval Workflow ID’s
PS_EOAW_LOG
PS_EOAW_MONDIS_DTL
PS_EOAW_MONDIS_HDR
PS_EOAW_NOTIFY SAC_AW Process Approval Process Notifications
PS_EOAW_NOTIFYDEF SAC_AW Process Approval Process Notifications
PS_EOAW_NOT_USER Notification setup table Used to store the different notification user lists. Used at the time of an approval event being fired.
PS_EOAW_NOT_USRDEF Notification setup table Used to store the different notification user lists. Used at the time of an approval event being fired.
PS_EOAW_NTF_CHLD Email Recipients The recipient list that is tied by parent_seq_nbr to sac_aw_ntf_prnt
PS_EOAW_NTF_PRNT Used to send email offline Consolidated email information that will be used to process email notifications offline.
PS_EOAW_PATH Approval Path Definition Approval Path Definition
PS_EOAW_PRCS Approval Process Definition This table holds the Approval Process definition properties
PS_EOAW_STAGE Approval Stage Approval Stage
PS_EOAW_STEP Approval Step Approval Step
PS_EOAW_STEPINST Instance of approval step
PS_EOAW_TIMEOUT Stores escalation options In order to make timeouts as configurable as possible, they are now removed from the sac_aw_path table
PS_EOAW_TIMEOUTDEF Stores escalation options In order to make timeouts as configurable as possible, they are now removed from the sac_aw_path table
PS_EOAW_TO_LOG Tracking mechanism for timeout Records all escalations when they are sent.   Allows us to send the most dire timeout notification on subsequent “doEscalate” calls.
PS_EOAW_TXN Approval Transaction Registry
PS_EOAW_TXN_CFG Approval Notifications Header
PS_EOAW_TXN_LBL Approval Transaction Levels Defines the approval levels the transaction supports. Some application transactions only support Header level.
PS_EOAW_TXN_LVL Approval Transaction Levels Defines the approval levels the transaction supports. Some application transactions only support Header level.
PS_EOAW_UL_ATTRIB
PS_EOAW_USERINST Step inst assigner to user
PS_EOAW_USRMON_CFG
PS_EOAW_WL Main Approval Worklist Worklist used for all Approvals
PS_EOAW_XREF_WRK
PS_CCUTSTHDR_TEOA CCU Audit Detail Table
PS_CCUTSTLN_TEOA CCU Audit Detail Table
PS_CCUTSTSCH_TEOA CCU Audit Detail Table
PS_CCUTSTVCH_TEOA CCU Audit Detail Table
PS_GVT_LEOAREA_TBL GVT: LEO Special Pay Area Tbl GVT:   This table is used in conjunction with the GVT_LOCPAY_AREA and LOCATION tables to determine the appropriate Locality Pay Percentage to use for salary computations.   The appropriate percentage for Law Enforcement Officers (LEOs) differs from regular Locality Pay.
PS_RUNCNTL_EOAWADT EOAW Audit Report run contorl for eoaw audit report
Advertisements
Peoplesoft Tables

Effdt SQL in Peoplesoft in Different way

By Default , Peoplesoft creates sql through PS QUERY . But this SQL does not work in Cognos Framework Manager and Cognos Reports.The same SQL can be created in a different way as follows.

JOBCODE_TBL

Select   PS_JOBCODE_TBL.*  from PS_JOBCODE_TBL , (  SELECT SETID,JOBCODE,MAX(EFFDT)  AS  MAX_EFFDT
FROM PS_JOBCODE_TBL WHERE EFFDT <= CURRENT_TIMESTAMP GROUP BY SETID,JOBCODE ) AS PS_JOBCODE_TBL_MAX_EFFDT
WHERE
PS_JOBCODE_TBL.SETID= PS_JOBCODE_TBL_MAX_EFFDT.SETID  AND
PS_JOBCODE_TBL.JOBCODE= PS_JOBCODE_TBL_MAX_EFFDT.JOBCODE AND
PS_JOBCODE_TBL.EFFDT= PS_JOBCODE_TBL_MAX_EFFDT.MAX_EFFDT

POSITION_DATA

Select   PS_POSITION_DATA.*  from PS_POSITION_DATA , (  SELECT POSITION_NBR,MAX(EFFDT)  AS  MAX_EFFDT
FROM PS_POSITION_DATA WHERE EFFDT <= CURRENT_TIMESTAMP GROUP BY POSITION_NBR ) AS PS_POSITION_DATA_MAX_EFFDT
WHERE
PS_POSITION_DATA.POSITION_NBR= PS_POSITION_DATA_MAX_EFFDT.POSITION_NBR AND
PS_POSITION_DATA.EFFDT= PS_POSITION_DATA_MAX_EFFDT.MAX_EFFDT

JOB

SELECT
PS_JOB.*
FROM
PS_JOB PS_JOB ,
(   SELECT EMPLID , EMPL_RCD, MAX(EFFDT) AS MAX_EFFDT FROM PS_JOB    WHERE EFFDT <= CURRENT_TIMESTAMP  GROUP BY EMPLID, EMPL_RCD ) AS PS_JOB_MAX_EFFDT ,
(   SELECT EMPLID, EMPL_RCD, EFFDT, MAX(PS_JOB.EFFSEQ) AS MAX_EFFSEQ   FROM  PS_JOB  WHERE EFFDT <= CURRENT_TIMESTAMP GROUP BY PS_JOB.EMPLID, PS_JOB.EMPL_RCD, PS_JOB.EFFDT)  AS PS_JOB_MAX_EFFSEQ
WHERE
PS_JOB_MAX_EFFDT.EMPLID = PS_JOB.EMPLID                                     AND
PS_JOB_MAX_EFFDT.EMPL_RCD = PS_JOB.EMPL_RCD                         AND
PS_JOB_MAX_EFFDT.MAX_EFFDT = PS_JOB.EFFDT                                AND
PS_JOB_MAX_EFFSEQ.MAX_EFFSEQ= PS_JOB.EFFSEQ                          AND
PS_JOB_MAX_EFFDT.EMPLID = PS_JOB_MAX_EFFSEQ.EMPLID             AND
PS_JOB_MAX_EFFDT.EMPL_RCD = PS_JOB_MAX_EFFSEQ.EMPL_RCD AND
PS_JOB_MAX_EFFDT.MAX_EFFDT = PS_JOB_MAX_EFFSEQ.EFFDT

DEPT_TBL

Select   PS_DEPT_TBL.*  from PS_DEPT_TBL , (  SELECT SETID,DEPTID,MAX(EFFDT)  AS  MAX_EFFDT
FROM PS_DEPT_TBL WHERE EFFDT <= CURRENT_TIMESTAMP GROUP BY SETID,DEPTID ) AS PS_DEPT_TBL_MAX_EFFDT
WHERE
PS_DEPT_TBL.SETID= PS_DEPT_TBL_MAX_EFFDT.SETID  AND
PS_DEPT_TBL.DEPTID= PS_DEPT_TBL_MAX_EFFDT.DEPTID AND
PS_DEPT_TBL.EFFDT= PS_DEPT_TBL_MAX_EFFDT.MAX_EFFDT

Effdt SQL in Peoplesoft in Different way