GPCH_AUDT_SETVW (SQL View)	Index Back
GPCH Audit - Module Tbl GPCH Audit - Module Tbl

GPCH_AUDT_SETVW

(SQL View)

GPCH Audit - Module Tbl

SELECT GPCH_AUDT_MODULEID , EFFDT , EFF_STATUS , DESCR , COUNTRY , GPCH_AUDT_TYPE , GPCH_AUDT_DOMAINID , GPCH_AUDT_SEQNBR , GPCH_PIN_NUM01 + 50000000 , GPCH_PIN_NUM02 + 50000000 , GPCH_AUDT_TAG01 , GPCH_AUDT_TAG02 , GPCH_PIN_NUM03 + 50000000 , GPCH_PIN_NUM04 + 50000000 , GPCH_AUDT_ADJ_TYP1 , GPCH_AUDT_ADJ_TYP2 , GPCH_AUDT_TOT_TYP1 , GPCH_AUDT_DATA_SRC , GPCH_AUDT_TOT_TYP2 FROM PS_GPCH_AUDT_SETUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPCH_AUDT_MODULEID Character(4) VARCHAR2(4) NOT NULL Domain Set ID for the ELM Domain Sets

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Default Value: CHE

6 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

7 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

8 GPCH_AUDT_SEQNBR Number(5,0) INTEGER NOT NULL Audit Total Type: S --> Sum C --> Count
C=Count
S=Sum

9 GPCH_PIN_NUM01 Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: GPCH_AUDT_PINVW

10 GPCH_PIN_NUM02 Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: GPCH_AUDT_PINVW

11 GPCH_AUDT_TAG01 Character(50) VARCHAR2(50) NOT NULL Domain Set ID for the ELM Domain Sets

12 GPCH_AUDT_TAG02 Character(50) VARCHAR2(50) NOT NULL Domain Set ID for the ELM Domain Sets

13 GPCH_PIN_NUM03 Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: GPCH_AUDT_EDAVW

14 GPCH_PIN_NUM04 Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: GPCH_AUDT_EDAVW

15 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

16 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

17 GPCH_AUDT_TOT_TYP1 Character(1) VARCHAR2(1) NOT NULL Audit Total Type: S --> Sum C --> Count
C=Count
S=Sum
Default Value: S

18 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

19 GPCH_AUDT_TOT_TYP2 Character(1) VARCHAR2(1) NOT NULL Audit Total Type: S --> Sum C --> Count
C=Count
S=Sum
Default Value: S

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPCH_AUDT_MODULEID	Character(4)	VARCHAR2(4) NOT NULL	Domain Set ID for the ELM Domain Sets
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: CHE
6	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
7	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
8	GPCH_AUDT_SEQNBR	Number(5,0)	INTEGER NOT NULL	Audit Total Type: S --> Sum C --> Count C=Count S=Sum
9	GPCH_PIN_NUM01	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPCH_AUDT_PINVW
10	GPCH_PIN_NUM02	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPCH_AUDT_PINVW
11	GPCH_AUDT_TAG01	Character(50)	VARCHAR2(50) NOT NULL	Domain Set ID for the ELM Domain Sets
12	GPCH_AUDT_TAG02	Character(50)	VARCHAR2(50) NOT NULL	Domain Set ID for the ELM Domain Sets
13	GPCH_PIN_NUM03	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPCH_AUDT_EDAVW
14	GPCH_PIN_NUM04	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPCH_AUDT_EDAVW
15	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
16	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
17	GPCH_AUDT_TOT_TYP1	Character(1)	VARCHAR2(1) NOT NULL	Audit Total Type: S --> Sum C --> Count C=Count S=Sum Default Value: S
18	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
19	GPCH_AUDT_TOT_TYP2	Character(1)	VARCHAR2(1) NOT NULL	Audit Total Type: S --> Sum C --> Count C=Count S=Sum Default Value: S