| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Field used for element packaging
|
| 2 |
GPCH_AUDT_MODULEID |
Character(4) |
VARCHAR2(4) NOT NULL |
Domain Set ID for the ELM Domain Sets
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: CHE
|
| 7 |
GPCH_AUDT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Audit Type:
01 --> Syncrhonous Audit
02 --> Internal Integrity Audit
03 --> External Integrity Audit
01=Synchronous Audit
02=Internal Integrity Audit
03=External Integrity Audit
Default Value: 01
|
| 8 |
GPCH_AUDT_DOMAINID |
Character(1) |
VARCHAR2(1) NOT NULL |
Domain ID
1=Base (AL08)
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=KSTVQ
|
| 9 |
GPCH_AUDT_SEQNBR |
Number(5,0) |
INTEGER NOT NULL |
Audit Total Type:
S --> Sum
C --> Count
C=Count
S=Sum
|
| 10 |
GPCH_PIN_NUM01 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 11 |
GPCH_PIN_NUM02 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 12 |
GPCH_AUDT_TAG01 |
Character(50) |
VARCHAR2(50) NOT NULL |
Domain Set ID for the ELM Domain Sets
|
| 13 |
GPCH_AUDT_TAG02 |
Character(50) |
VARCHAR2(50) NOT NULL |
Domain Set ID for the ELM Domain Sets
|
| 14 |
GPCH_PIN_NUM03 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 15 |
GPCH_PIN_NUM04 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 16 |
GPCH_AUDT_ADJ_TYP1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Domain Set ID for the ELM Domain Sets
A=Add
S=Subtract
Default Value: A
|
| 17 |
GPCH_AUDT_ADJ_TYP2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Domain Set ID for the ELM Domain Sets
A=Add
S=Subtract
Default Value: A
|
| 18 |
GPCH_AUDT_TOT_TYP1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Total Type:
S --> Sum
C --> Count
C=Count
S=Sum
Default Value: S
|
| 19 |
GPCH_AUDT_DATA_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Data Source:
S --> Sum
C --> Count
P --> Person
C=Salary Counter
P=Person
S=Salary Total
Default Value: P
|
| 20 |
GPCH_AUDT_TOT_TYP2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Total Type:
S --> Sum
C --> Count
C=Count
S=Sum
Default Value: S
|