FPMWORKTABLE(SQL Table) |
Index Back |
---|---|
Wktbl for Job-compo fusionThis 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). |