FPAEERETROSP(SQL Table) |
Index Back |
|---|---|
Retroactivity Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | FP_CNL_ROW | Character(1) | VARCHAR2(1) NOT NULL |
Canceled row indicator in case a row is deleted.
Y/N Table Edit |
| 6 | FP_INST_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Instance Status
D=Request R=Actual |
| 7 | FP_ACTION_REF | Character(8) | VARCHAR2(8) NOT NULL | Request Reference |
| 8 | FP_NOTIF_REF | Character(8) | VARCHAR2(8) NOT NULL | Order reference |
| 9 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 10 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 11 | FP_TBL_CD | Character(1) | VARCHAR2(1) NOT NULL |
Step increment indicator
A=Assignment Table C=CareerTable D=Request Table E=Absence Table F=Assignment History G=Statutory Position History H=Carrer History I=Other DataTable J=Premium Hist K=Work Time History L=Compensaton History M=Premium N=Order Table O=Contract Table P=Bonus Table R=Compensation Table S=Statutory Position Table T=Other Data History U=Bonus History W=Work Time Table |