GPS_ALLOW_TYP0=Normal Child
1=Obstructs Child
2=Foreigner Child
EFFDTDefault Value: %date
GPS_CHILD_IDENTLANGUAGE_CDGPS_AMT_LNG(SQL Table) |
Index Back |
|---|---|
DEU - Child AllowanceRelated Language Table: Child 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |