| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: GPCH_PK_DAT.EMPLID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
Default Value: GPCH_PK_DAT.EMPL_RCD
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %Date
|
| 4 |
GPCH_SI_PROV_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Provider Type
0=Identify
1=Others
2=UVG-LAA
3=KTG-AMC
4=UVGZ-LAAC
5=FAK-CAF
6=BVG-LPP
7=AHV-AVS
8=LAW-CDS
9=BFS-OFS
A=QST-IS
B=Write File
C=Base AL08
D=GRFI-FRFI
E=EO-APG
I=BNK_BNQ
Default Value: 6
|
| 5 |
GPCH_SI_PROV_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Provider Code
Default Value: GPCH_EEPKPVC_VW.GPCH_SI_PROV_CD
Prompt Table:
GPCH_SI_PRV_VW1
|
| 6 |
GPCH_PK_SD_EMA |
Character(2) |
VARCHAR2(2) NOT NULL |
Family allowance EMA (Entry, Modification, Withdrawal) mutation event.
Prompt Table:
GPCH_PK_SDREASO
|
| 7 |
GPCH_AL_CPAY_ENDDT |
Date(10) |
DATE NOT NULL |
Current Pay End Date
|
| 8 |
EVENT_DT |
Date(10) |
DATE NOT NULL |
Event Date
|
| 9 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 10 |
END_DT |
Date(10) |
DATE |
end date
|
| 11 |
ITER_TRGR_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Iterative Trigger Source
B=Batch
F=Benefits Administration
O=Online
S=Mass Trigger
U=Uncancel
V=Unsuspend
W=Time & Labor
Z=Time & Labor Feed
|
| 12 |
ITER_TRGR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Iterative Trigger Status
C=Cancelled
I=InProcess
P=Processed
U=UnProcessed
|
| 13 |
GPCH_RP_AMOUNT1 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 14 |
GPCH_RP_AMOUNT2 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|