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.

FPMWORKTABLE

(SQL Table)

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).

#	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).