INT_PCSRCPN_PRT_AGTGRP

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MD5_KEY CHARACTER VARYING(128) 128
2 REC_TYPE_CD INTEGER 4
3 BATCH_KEY INTEGER 4
4 RUN_REG_KEY BIGINT 8
5 ROW_INSERT_DT TIMESTAMP 8
6 ROW_EFFECTIVE_DT TIMESTAMP 8
7 AUDIT_FLAG CHARACTER VARYING(1) 1
8 COMPANY SMALLINT 2
9 AGTGROUP INTEGER 4
10 ACTIVFROM INTEGER 4
11 ACTIVTO INTEGER 4
12 AGTCLUSTR CHARACTER VARYING(4) 4
13 GRPNAME CHARACTER VARYING(60) 60
14 STATUS CHARACTER VARYING(1) 1
15 TRANDATE INTEGER 4
16 TRANTIME INTEGER 4
17 TRANUSER CHARACTER VARYING(8) 8
18 AGTGRPSTMT CHARACTER VARYING(1) 1
19 EMAILADD CHARACTER VARYING(120) 120