FPMACTPRTY_TBL(SQL Table) | 
Index Back | 
|---|---|
Retro Prcs Rules | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL | 
Action
 Prompt Table: FPMACTION_VW2  | 
|
| 2 | Character(3) | VARCHAR2(3) NOT NULL | 
Action after Retroactive Event
 Prompt Table: FPAACTNCARE_VW  | 
|
| 3 | FP_UP_CN_END | Character(1) | VARCHAR2(1) NOT NULL | 
Retroactive Update Action
 A=End S=Delete Default Value: A  | 
| 4 | LAST_UPDATE_DATE | Date(10) | DATE | 
Date of last update
 Default Value: %Date  |