GPCH_AUDT_SET_MODLEFFDTDefault Value: %date
GPCH_AUDT_MODULEIDPrompt Table: GPCH_AUDT_SETUP
Default Value: 1
A=Absolute Value
N=Negative Sign
P=Positive Sign
Default Value: A
GPCH_AUDT_SETDT(SQL Table) |
Index Back |
|---|---|
GPCH Audit - Set of Module DtlGPCH Audit - Set of Module Details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_AUDT_SET_MODL |
Character(3) | VARCHAR2(3) NOT NULL | Domain Set ID for the ELM Domain Sets |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPCH_AUDT_MODULEID |
Character(4) | VARCHAR2(4) NOT NULL |
Domain Set ID for the ELM Domain Sets
Prompt Table: GPCH_AUDT_SETUP |
| 4 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | GPCH_AUDT_LEVEL | Number(13,2) | DECIMAL(12,2) NOT NULL |
Employer Contribution BU %
Default Value: 1 |
| 6 | GPCH_AUDT_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Sign
A=Absolute Value N=Negative Sign P=Positive Sign Default Value: A |