SS_REGIM_CD_GPFRAGPFR_DU_CON_DES(SQL View) |
Index Back |
|---|---|
Contribution descriptionGPFR contribution Description |
| SELECT URS.SS_REGIM_CD_GPFRA ,URS.GPFR_DUCS_CON_TYP1 ,URS.DESCR FROM PS_GPFR_URS_RATES URS WHERE URS.EFFDT = ( SELECT MAX(URS1.EFFDT) FROM PS_GPFR_URS_RATES URS1 WHERE URS1.SS_REGIM_CD_GPFRA = URS.SS_REGIM_CD_GPFRA AND URS1.EFFDT <= %CurrentDateIn) AND URS.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SS_REGIM_CD_GPFRA |
Number(3,0) | SMALLINT NOT NULL | This field is used as a System Element in Global Payroll. It is a French specific field. |
| 2 | GPFR_DUCS_CON_TYP1 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |