EMPLIDDefault Value: JOB.EMPLID
EMPL_RCDDefault Value: JOB.EMPL_RCD
BGN_DTEND_DTGPS_CHILD_ALLOW_NRGPDE_AL_SEQCE_NBRGPS_NOTIFIC_SRCADP=ADP
HR=Human Resources
Y/N Table Edit
Default Value: N
GPS_INBOUND_DTA(SQL Table) |
Index Back |
|---|---|
GPS INBOUND DATAGeman Public Sector table This integration table is populated by ADP. Holding Inbound infromation after the payroll process has been run successfully. Child Allowances that has been paid out to employees should be stored here. It should be populated by PAISY. The data in this table is used by HCM for reporting on the child/family allowances. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: JOB.EMPLID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: JOB.EMPL_RCD |
| 3 | BGN_DT |
Date(10) | DATE | Begin Date |
| 4 | END_DT |
Date(10) | DATE | end date |
| 5 | GPS_CHILD_ALLOW_NR |
Character(50) | VARCHAR2(50) NOT NULL | Child Allow. Nbr |
| 6 | GPDE_AL_SEQCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence |
| 7 | GPS_NOTIFIC_SRC |
Character(4) | VARCHAR2(4) NOT NULL |
Post Management Notification Source
ADP=ADP HR=Human Resources |
| 8 | GPS_BASE_AMOUNT | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Child Allownace Base Amount |
| 9 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 10 | BIRTHPLACE | Character(30) | VARCHAR2(30) NOT NULL | Birth Location |
| 11 | GPDE_DV_TIME | Time(15) | TIMESTAMP | Timestamp for DateTime Comparisons. |
| 12 | GPS_CHECK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Marked as Read flag.
Y/N Table Edit Default Value: N |