Field Index

SQL Mapping

create

This event is generated when a new process audit object is created

Notes

This object can be read by the owner or any billing group leader within the brand who is an ancestor of the owner.
This object can be modified by the owner or any billing group leader within the brand who is an ancestor of the owner.
This object can be created by anyone.

Field Index

Type	Field Name
substruct	PIN_FLD_INHERITED_INFO
poid	PIN_FLD_POID
poid	PIN_FLD_ACCOUNT_OBJ
string	PIN_FLD_PROGRAM_NAME
string	PIN_FLD_PROCESS_NAME
timestamp	PIN_FLD_PROCESS_START_T
timestamp	PIN_FLD_PROCESS_END_T
int	PIN_FLD_VERSION_ID
substruct	PIN_FLD_BATCH_STAT
string	PIN_FLD_BATCH_ID
int	PIN_FLD_BATCH_TYPE
array	PIN_FLD_GROUP_DETAILS
string	PIN_FLD_ORIGINAL_BATCH_ID
int	PIN_FLD_EVENT_COUNT
decimal	PIN_FLD_EVENT_DURATION
decimal	PIN_FLD_VOLUME_SENT
decimal	PIN_FLD_VOLUME_RECEIVED
decimal	PIN_FLD_RETAIL_VALUE
decimal	PIN_FLD_WHOLESALE_VALUE
decimal	PIN_FLD_DISCOUNT_VALUE
string	PIN_FLD_OUTPUT_STREAM
string	PIN_FLD_REVENUE_STREAM
string	PIN_FLD_EDR_STATUS
string	PIN_FLD_SERVICE_TYPE
enum	PIN_FLD_SUSPENSE_REASON
timestamp	PIN_FLD_USAGE_START_T
timestamp	PIN_FLD_USAGE_END_T
string	PIN_FLD_SUSPENDED_FROM_BATCH_ID
decimal	PIN_FLD_OLD_RETAIL_VALUE
decimal	PIN_FLD_OLD_DISCOUNT_VALUE

Field Details

substruct PIN_FLD_INHERITED_INFO

Notes

Can be specified on object creation
Can be modified

poid PIN_FLD_POID

Link to the process_audit object.

Notes

Required on object creation
Cannot be modified

poid PIN_FLD_ACCOUNT_OBJ

Poid of the Account object

Notes

Can be specified on object creation
Can be modified

string PIN_FLD_PROGRAM_NAME

Name of the Program that is generating the process audit information

Notes

Required on object creation
Cannot be modified
Maximum length is 30 bytes

string PIN_FLD_PROCESS_NAME

Name of the Process from which the audit info is recorded

Notes

Can be specified on object creation
Can be modified
Maximum length is 30 bytes

timestamp PIN_FLD_PROCESS_START_T

The process start time.

Notes

Can be specified on object creation
Can be modified

timestamp PIN_FLD_PROCESS_END_T

The process end time.

Notes

Can be specified on object creation
Can be modified

int PIN_FLD_VERSION_ID

Version Number of Object

Notes

Can be specified on object creation
Can be modified

substruct PIN_FLD_BATCH_STAT

Substruct containing EDR Batch Id and Type

Notes

Can be specified on object creation
Can be modified

string PIN_FLD_BATCH_ID

Batch Id

Notes

Required on object creation
Cannot be modified
Maximum length is 80 bytes

int PIN_FLD_BATCH_TYPE

Batch Type

Notes

Required on object creation
Can be modified

array PIN_FLD_GROUP_DETAILS

Group details

Notes

Can be specified on object creation
Can be modified

string PIN_FLD_ORIGINAL_BATCH_ID

Original batch Id

Notes

Required on object creation
Cannot be modified
Maximum length is 80 bytes

int PIN_FLD_EVENT_COUNT

Total number of EDRs

Notes

Can be specified on object creation
Can be modified

decimal PIN_FLD_EVENT_DURATION

Total Duration

Notes

Can be specified on object creation
Can be modified

decimal PIN_FLD_VOLUME_SENT

Total volume of data sent

Notes

Can be specified on object creation
Can be modified

decimal PIN_FLD_VOLUME_RECEIVED

Total volume of data received

Notes

Can be specified on object creation
Can be modified

decimal PIN_FLD_RETAIL_VALUE

Total Retail charge amount

Notes

Can be specified on object creation
Can be modified

decimal PIN_FLD_WHOLESALE_VALUE

Total wholesale charge amount

Notes

Can be specified on object creation
Can be modified

decimal PIN_FLD_DISCOUNT_VALUE

Total Discount Value

Notes

Can be specified on object creation
Can be modified

Output Stream Identifierwill be available only if poid type is one of the following : /process_audit/batchstat/outputstream/process_audit/batchstat/svctype_revstream_outputstream/process_audit/batchstat/svctype_revstream_status_outputstream

Notes

Can be specified on object creation
Cannot be modified
Maximum length is 80 bytes

string PIN_FLD_REVENUE_STREAM

Revenue Stream Identifierwill be available only if poid type is one of the following : /process_audit/batchstat/revstream/process_audit/batchstat/revstream_status/process_audit/batchstat/revstream_svctype/process_audit/batchstat/revstream_svctype_status/process_audit/batchstat/svctype_revstream/process_audit/batchstat/svctype_revstream_status/process_audit/batchstat/svctype_revstream_outputstream/process_audit/batchstat/svctype_revstream_status_outputstream

Notes

Can be specified on object creation
Cannot be modified
Maximum length is 80 bytes

string PIN_FLD_EDR_STATUS

EDR Status Identifierwill be available only if poid type is one of the following : /process_audit/batchstat/status/process_audit/batchstat/revstream_status/process_audit/batchstat/revstream_svctype_status/process_audit/batchstat/svctype_revstream_status/process_audit/batchstat/svctype_status/process_audit/batchstat/svctype_revstream_status_outputstream

Notes

Can be specified on object creation
Cannot be modified
Maximum length is 80 bytes

string PIN_FLD_SERVICE_TYPE

Service Type Identifierwill be available only if poid type is one of the following : /process_audit/batchstat/revstream_svctype/process_audit/batchstat/revstream_svctype_status/process_audit/batchstat/svctype/process_audit/batchstat/svctype_revstream/process_audit/batchstat/svctype_revstream_outputstream/process_audit/batchstat/svctype_revstream_status/process_audit/batchstat/svctype_revstream_status_outputstream/process_audit/batchstat/svctype_status

Notes

Can be specified on object creation
Cannot be modified
Maximum length is 80 bytes

enum PIN_FLD_SUSPENSE_REASON

Suspense Code Identifierwill be available only if poid type is /process_audit/batchstat/suspense

Notes

Can be specified on object creation
Cannot be modified

timestamp PIN_FLD_USAGE_START_T

Earliest Call Time

Notes

Can be specified on object creation
Can be modified

timestamp PIN_FLD_USAGE_END_T

Last Call Time

Notes

Can be specified on object creation
Can be modified

string PIN_FLD_SUSPENDED_FROM_BATCH_ID

Suspended From batch Id

Notes

Required on object creation
Cannot be modified
Maximum length is 80 bytes

decimal PIN_FLD_OLD_RETAIL_VALUE

Old Retail Amount

Notes

Can be specified on object creation
Can be modified

decimal PIN_FLD_OLD_DISCOUNT_VALUE

Old Discount Value

Notes

Can be specified on object creation
Can be modified

SQL Mapping

Links

/event/notification/process_audit SQL Mapping

Type	Field Name	Table	Column Name
derived-class	/event/notification/process_audit/create
substruct	PIN_FLD_INHERITED_INFO
poid	PIN_FLD_POID
poid	PIN_FLD_ACCOUNT_OBJ
string	PIN_FLD_PROGRAM_NAME
string	PIN_FLD_PROCESS_NAME
timestamp	PIN_FLD_PROCESS_START_T
timestamp	PIN_FLD_PROCESS_END_T
int	PIN_FLD_VERSION_ID
substruct	PIN_FLD_BATCH_STAT
string	PIN_FLD_BATCH_ID
int	PIN_FLD_BATCH_TYPE
array	PIN_FLD_GROUP_DETAILS
string	PIN_FLD_ORIGINAL_BATCH_ID
int	PIN_FLD_EVENT_COUNT
decimal	PIN_FLD_EVENT_DURATION
decimal	PIN_FLD_VOLUME_SENT
decimal	PIN_FLD_VOLUME_RECEIVED
decimal	PIN_FLD_RETAIL_VALUE
decimal	PIN_FLD_WHOLESALE_VALUE
decimal	PIN_FLD_DISCOUNT_VALUE
string	PIN_FLD_OUTPUT_STREAM
string	PIN_FLD_REVENUE_STREAM
string	PIN_FLD_EDR_STATUS
string	PIN_FLD_SERVICE_TYPE
enum	PIN_FLD_SUSPENSE_REASON
timestamp	PIN_FLD_USAGE_START_T
timestamp	PIN_FLD_USAGE_END_T
string	PIN_FLD_SUSPENDED_FROM_BATCH_ID
decimal	PIN_FLD_OLD_RETAIL_VALUE
decimal	PIN_FLD_OLD_DISCOUNT_VALUE
Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size.

Field Index

This Class