GPS_ALLOW_TYP0=Normal Child
1=Obstructs Child
2=Foreigner Child
EFFDTDefault Value: %date
GPS_CHILD_IDENTGPS_CHILD_AMT(SQL Table) |
Index Back |
|---|---|
DEU - Child AllowanceChild Allowance Type and Amounts Effective Dated. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPS_ALLOW_TYP |
Character(1) | VARCHAR2(1) NOT NULL |
Child Allowance Type
0=Normal Child 1=Obstructs Child 2=Foreigner Child |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPS_CHILD_IDENT |
Character(20) | VARCHAR2(20) NOT NULL | Child Number |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | GPS_AMT_CHILD_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Allowance Amount Child 1 |