FPY_CONFIG_TBL(SQL Table) |
Index Back |
|---|---|
Configuration TableConfiguration Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FPY_COMP_RTCD | Character(6) | VARCHAR2(6) NOT NULL |
Default Rate Code
Prompt Table: COMP_RATECD_TBL |
| 2 | FPY_INCR_PATH | Character(254) | VARCHAR2(254) NOT NULL | Incremental File Path for Integration |
| 3 | FPY_BULK_PATH | Character(254) | VARCHAR2(254) NOT NULL | UCM File Path for Integration |
| 4 | FPY_BEN_PROGRAM | Character(10) | VARCHAR2(10) NOT NULL |
Benefits Program
Prompt Table: BEN_DEFN_PGM |
| 5 | FPY_SETID | Character(50) | VARCHAR2(50) NOT NULL |
Setid
Prompt Table: SETID_TBL |
| 6 | PU_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Paysheet update source.
AM=Absence Management ER=Recruiting Interface EX=Expense Interface IM=SIM Interface OT=Other Sources PL=Lifetime Balance Payout USF RP=Rapid Paysheets SP=Stock Admin - ESPP Refunds ST=Stock Admin - Options & ESPP VC=Variable Compensation VF=Bonus from Fusion WI=What-If |
| 7 | FPY_PU_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
PU Source for Absence
T=Fusion PU Source |