FPMWORKTABLE

(SQL Table)
Index Back

Wktbl for Job-compo fusion

This table is used to store temporarily data to indicate which component table rows have seen events concerning JOB for a number of EMPLID at a time. FUSI_JOB.SQC uses data stored in this table to generate JOB rows from component table rows. It is currently not indexed as it is a write-once, read-once worktable. Tests should be run to see what effect, if any, indexation would have on performance.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE Effective Date
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

6 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).