FPMSTATACTDOC(SQL Table) |
Index Back |
|---|---|
Status/Action DocumentsPS - Selects - by Employee Status and Action - the Word documents to be edited (max 5). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FP_STATUSEE_CD |
Character(1) | VARCHAR2(1) NOT NULL |
Employee status
Prompt Table: FPMSTATUSEE_TBL |
| 2 | ACTION |
Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: FPMACTION_VW2 |
| 3 | FP_TYP_NOT |
Character(1) | VARCHAR2(1) NOT NULL |
Type of Order
A=Abrogations R=Return S=Orders Default Value: S |
| 4 | FP_WORD01 | Character(6) | VARCHAR2(6) NOT NULL |
Document 1
Prompt Table: FPMDOCWORD_TBL |
| 5 | FP_WORD02 | Character(6) | VARCHAR2(6) NOT NULL |
Document 2
Prompt Table: FPMDOCWORD_TBL |
| 6 | FP_WORD03 | Character(6) | VARCHAR2(6) NOT NULL |
Document 3
Prompt Table: FPMDOCWORD_TBL |
| 7 | FP_WORD04 | Character(6) | VARCHAR2(6) NOT NULL |
Document 4
Prompt Table: FPMDOCWORD_TBL |
| 8 | FP_WORD05 | Character(6) | VARCHAR2(6) NOT NULL |
Document 5
Prompt Table: FPMDOCWORD_TBL |