Service Price List

Table Name spl_moef_model_effect

Table Comment To store the modal effectivity details of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

moef_ouinstance

int

NOT NULL

Ouinstance

moef_plno

varchar(40)

NOT NULL

model service price list

moef_revno

varchar(40)

NOT NULL

model service price list revision no

moef_lineno

int

NOT NULL

line no

moef_model_no

varchar(20)

NOT NULL

Model no

moef_model_ou

int

NOT NULL

Model Ouinstance

moef_created_by

varchar(30)

NOT NULL

Created by

moef_created_date

datetime

NOT NULL

created date

moef_modified_by

varchar(30)

NULL

Modified By

moef_modified_date

datetime

NULL

Modified Date

Table Name spl_moefH_model_effect_Hist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

moefH_ouinstance

int

NOT NULL

instance from Application Table

moefH_plno

varchar(40)

NOT NULL

pricelist  from Application Table

moefH_revno

varchar(40)

NOT NULL

revision no from Application Table

moefH_lineno

int

NOT NULL

line no from Application Table

moefH_model_no

varchar(20)

NOT NULL

model no from Application Table

moefH_model_ou

int

NOT NULL

model instance from Application Table

moefH_created_by

varchar(30)

NOT NULL

created by from Application Table

moefH_created_date

datetime

NOT NULL

created date from Application Table

moefH_modified_by

varchar(30)

NULL

modified by from Application Table

moefH_modified_date

datetime

NULL

modified date from Application Table

Table Name spl_nbs_nbill_service

Table Comment To store the non billable service details of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

nbs_ouinstance

int

NOT NULL

instance

nbs_plno

varchar(40)

NOT NULL

service pricelist no

nbs_revno

varchar(40)

NOT NULL

service pricelist revision no

nbs_lineno

int

NOT NULL

line no for multi line reference

nbs_wkunit_ou

int

NOT NULL

workunit instance

nbs_wkunit_type

varchar(5)

NOT NULL

workunit type will be task standard procedure Aircraft work package component work Package Maint change request

nbs_wkunit_no

varchar(30)

NOT NULL

work unit no

nbs_auth_units

varchar(255)

NOT NULL

authorizing organisation unit

nbs_created_by

varchar(30)

NOT NULL

created by

nbs_created_date

datetime

NOT NULL

created date

nbs_modified_by

varchar(30)

NULL

modified by

nbs_modified_date

datetime

NULL

modified date

Table Name spl_nbsH_nbill_service_Hist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

nbsH_ouinstance_

int

NULL

instance from application Table

nbsH_plno

varchar(40)

NULL

service price list from Application table

nbsH_revno

varchar(40)

NULL

revision no of service pricelist from application table

nbsH_lineno

int

NULL

line no from application table for multi line reference

nbsH_wkunit_ou

int

NULL

work unit instance from application table

nbsH_wkunit_type

varchar(5)

NULL

work unit type from application table

nbsH_wkunit_no

varchar(30)

NULL

wkunit_no from application table

nbsH_auth_units

varchar(255)

NULL

authorizing organization from application table

nbsH_created_by

varchar(30)

NULL

created by from application table

nbsH_created_date

datetime

NULL

created date from application table

nbsH_modified_by

int

NULL

Modified by from application table

nbsH_modified_date

datetime

NULL

Modified date from application table

Table Name spl_parameter_details

Table Comment To store the parameter details of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ComponentName

varchar(20)

NOT NULL

component Name

ParamCategory

varchar(10)

NOT NULL

Parameter Category

ParamType

varchar(25)

NOT NULL

Parameter Type

ParamCode

varchar(5)

NOT NULL

Parameter code

ParamDesc

varchar(80)

NOT NULL

Parameter Description

Langid

int

NOT NULL

Language ID

Sortby

int

NOT NULL

used to sort the values . Numeric Value

CreationDate

datetime

NOT NULL

Created Date

Table Name spl_pref_part_effect

Table Comment To store the part effectivity details of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pref_ouinstance

int

NOT NULL

ounistance

pref_plno

varchar(40)

NOT NULL

price list no

pref_revno

varchar(40)

NOT NULL

revision no

pref_lineno

int

NOT NULL

line no

srmpl_ouinstance

int

NULL

ounistance

pref_part_no

varchar(40)

NOT NULL

part no

pref_part_ou

int

NOT NULL

part created ou

pref_created_by

varchar(30)

NOT NULL

created by

pref_created_date

datetime

NOT NULL

created date

pref_modified_by

varchar(30)

NULL

modified by

pref_modified_date

datetime

NULL

modified date

Table Name spl_prefH_part_effect_Hist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

prefH_ouinstance

int

NOT NULL

instance

prefH_plno

varchar(40)

NOT NULL

price list no

prefH_revno

varchar(40)

NOT NULL

service price list revision no

prefH_lineno

int

NOT NULL

line no

prefH_part_no

varchar(40)

NOT NULL

part no

prefH_part_ou

int

NOT NULL

Part created ou

prefH_created_by

varchar(30)

NOT NULL

created by

prefH_created_date

datetime

NOT NULL

created date

prefH_modified_by

varchar(30)

NULL

Modified by

prefH_modified_date

datetime

NULL

Modified Date

Table Name spl_rcd_details

Table Comment Table stores the resource cost &nbspbreak up &nbspdepending on the time interval and the factor mentioned

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

rcd_ouinstance

int

NOT NULL

To store current processing instance

rcd_plno

varchar(40)

NOT NULL

Service pricelist no to which the corresponding RCD details were stored

rcd_revno

varchar(40)

NOT NULL

for the mentioned service pricelist’s revision no

rcd_lineno

int

NOT NULL

Unique field for line no to store Multiple RCD details for a service pricelist # , revision no combination

rcd_roster_code

varchar(25)

NULL

Quick code to store the roster code information

rcd_element

varchar(40)

NULL

For storing element information for the roster code defined

rcd_fromtime

varchar(15)

NULL

the starting time for the interval specification

rcd_totime

varchar(15)

NULL

To time

rcd_factor

numeric

NULL

Factor for the interval specified for the particular rcd and element combination

rcd_created_by

varchar(30)

NULL

created user id

rcd_created_date

datetime

NULL

created time

rcd_modified_by

varchar(30)

NULL

Modified user id

rcd_modified_date

datetime

NULL

Modified time

rcd_remarks

varchar(255)

NULL

Remarks for the rcd entry

rcd_day

varchar(5)

NULL

flag value to store whether the interval mentioned is full day or not

Table Name spl_rcdh_details_his

Table Comment History table for spl_rcd_details for movement of data during revising and activating the service pricelist no

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

rcdh_ouinstance

int

NOT NULL

processing instance

rcdh_plno

varchar(40)

NOT NULL

service pricelist no

rcdh_revno

varchar(40)

NOT NULL

revision no for the mentioned service pricelist no

rcdh_lineno

int

NOT NULL

unique field to have multiple RCD entries for the service pricelist# and revision no

rcdh_roster_code

varchar(25)

NOT NULL

Roster code for the service pricelist

rcdh_element

varchar(40)

NULL

Element defined for the roster code

rcdh_fromtime

varchar(15)

NULL

interval starting time

rcdh_totime

varchar(15)

NULL

interval ending time

rcdh_factor

numeric

NULL

factor defined for the interval

rcdh_created_by

varchar(30)

NULL

created user name

rcdh_created_date

datetime

NULL

created date

rcdh_modified_by

varchar(30)

NULL

modified user name

rcdh_modified_date

datetime

NULL

modified date

rcdh_remarks

varchar(255)

NULL

remarks given

rcdh_day

varchar(5)

NULL

flag value to store whether the interval mentioned is full day or not

Table Name spl_ropr_ro_price

Table Comment To store the repair pricing details of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ropr_mtrl_cost

numeric

NOT NULL

flat material cost for the repair

ropr_res_cost

numeric

NOT NULL

flat resource price rate /hr

ropr_rep_code

varchar(25)

NOT NULL

Repair process code Process codes from Logistics common master which are in active status

ropr_part_ou

int

NOT NULL

part created instance

ropr_modified_by

varchar(30)

NULL

modified by

ropr_misc_cost

numeric

NOT NULL

miscellaneous cost

ropr_created_date

datetime

NOT NULL

created date

ropr_created_by

varchar(30)

NOT NULL

created by

ropr_modified_date

datetime

NULL

modified date

ropr_plno

varchar(40)

NOT NULL

service pricelist no

ropr_revno

varchar(4)

NOT NULL

service price list revision no

ropr_ouinstance

int

NOT NULL

instance

ropr_part_no

varchar(40)

NOT NULL

part no

ropr_lineno

int

NOT NULL

line no for multi line reference

Table Name spl_roprH_ro_price_Hist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

roprH_ouinstance

int

NOT NULL

instance from Application Table

roprH_plno

varchar(40)

NOT NULL

pricelist no from Application Table

roprH_revno

varchar(40)

NOT NULL

revision no from Application Table

roprH_lineno

int

NOT NULL

line no from Application Table

roprH_part_no

varchar(40)

NOT NULL

part no from Application Table

roprH_part_ou

int

NOT NULL

part created instance from Application Table

roprH_rep_code

varchar(25)

NOT NULL

rep code from Application Table

roprH_mtrl_cost

numeric

NOT NULL

material cost from Application Table

roprH_res_cost

numeric

NOT NULL

resource cost from Application Table

roprH_misc_cost

numeric

NOT NULL

miscellaneous cost from Application Table

roprH_created_by

varchar(30)

NOT NULL

created by from Application Table

roprH_created_date

datetime

NOT NULL

created date from Application Table

roprH_modified_by

varchar(30)

NULL

modified by from Application Table

roprH_modified_date

datetime

NULL

modified date from Application Table

Table Name spl_srmpl_mtrl_policy

Table Comment To store the pricing policy for materials of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

srmpl_price_method

varchar(5)

NOT NULL

pricing method for the material can be direct workunitwise flat OEM price list customer wise pricelist

srmpl_part_plist

varchar(40)

NULL

part price list for the material

SRMPL_PRICING_FACTOR

numeric

NULL

pricing factor for the material

SRMPL_PART_CONDITION

varchar(25)

NULL

part condition of the material can be new servicable overhauled

srmpl_modified_by

varchar(30)

NULL

modified by

srmpl_part_plist_ou

int

NULL

part price list instance

srmpl_created_date

datetime

NOT NULL

created date

srmpl_created_by

varchar(30)

NOT NULL

created by

srmpl_modified_date

datetime

NULL

modified date

srmpl_plno

varchar(40)

NOT NULL

service pricelist no

srmpl_revno

varchar(40)

NOT NULL

service pricelist revision no

srmpl_ouinstance

int

NOT NULL

instance

srmpl_part_type

varchar(5)

NOT NULL

part type of the material can be component expendable consumable

srmpl_lineno

int

NOT NULL

line no for multi reference

Table Name spl_srmplH_mtrl_policy_Hist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

srmplH_ouinstance

int

NOT NULL

instance from application Table

srmplH_plno

varchar(40)

NOT NULL

price list no  from application Table

srmplH_revno

varchar(40)

NOT NULL

revision no from application Table

srmplH_lineno

int

NOT NULL

line no  from application Table

srmplH_part_type

varchar(5)

NOT NULL

part type from application Table

SRMPLH_PART_CONDITION

varchar(25)

NULL

part condition from application Table

SRMPLH_PRICING_FACTOR

numeric

NULL

pricing factor from application Table

srmplH_price_method

varchar(5)

NOT NULL

price method  from application Table

srmplH_part_plist

varchar(40)

NULL

part list from application Table

srmplH_part_plist_ou

int

NULL

part pricelist ou  from application Table

srmplH_created_by

varchar(30)

NOT NULL

created by  from application Table

srmplH_created_date

datetime

NOT NULL

created date from application Table

srmplH_modified_by

varchar(30)

NULL

Modified by from application Table

srmplH_modified_date

datetime

NULL

modified date from application Table

Table Name spl_srplh_hdr

Table Comment To store the main information of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

srplh_ouinstance

int

NOT NULL

current instance

srplh_plno

varchar(40)

NOT NULL

service price list no

srplh_revno

varchar(40)

NOT NULL

revision no auto generated

srplh_status

varchar(5)

NOT NULL

service price list status values will be Confirmed Active InActive Fresh Returned Canceled Revised

srplh_desc

varchar(150)

NOT NULL

service price list description

srplh_pl_category

varchar(40)

NULL

service price list category defined in category master

srplh_category_ou

int

NULL

category instance

srplh_eff_from

datetime

NOT NULL

service price list effectivity from date

srplh_eff_to

datetime

NULL

service price list effectivity TO date

srplh_remarks

varchar(255)

NULL

Remarks on service price list

srplh_currency

varchar(5)

NOT NULL

currency for service price list

srplh_oth_currency

varchar(5)

NOT NULL

other currency change applicability or not values will be applicable not applicable

srplh_price_basis

varchar(5)

NOT NULL

Pricing basis for the service price list values will be direct factored on service price list codes will be stored

srplh_std_spl

varchar(40)

NULL

standard service pricelist

srplh_std_spl_ou

int

NULL

standard service pricelist instance

srplh_price_factor

numeric

NULL

Pricing factor for service price list defined

srplh_mtrl_cost

varchar(5)

NULL

material cost of service price list

srplh_std_res_rate

numeric

NULL

resource rate for spl

SRPLH_STD_LBR_RATE_NRM

numeric

NULL

standard Normal Labour rate / hour

SRPLH_STD_LBR_RATE_OT

numeric

NULL

standard Normal Labour rate / hour for over time

SRPLH_STD_FAC_RATE

numeric

NULL

standard Normal Facility rate / hour

SRPLH_STD_PPL_NO

varchar(40)

NULL

standard part price list no

SRPLH_STD_PRICING_BASIS

varchar(5)

NULL

standard pricing basis values will be Cost Incurred Cost Plus Margin codes will be stored

SRPLH_STD_PRICING_FACTOR

numeric

NULL

standard pricing factor for external repair services

SRPLH_INACTPREVREV

varchar(25)

NULL

previous inactive revision no

srplh_file_name

varchar(50)

NULL

file name for reference

srplh_timestamp

int

NOT NULL

timestamp for not allowing more than one user to access same data

srplh_cancelcomments

varchar(255)

NULL

service price list if canceled comments for canceling

srplh_appComments

varchar(255)

NULL

approval comments

srplh_created_by

varchar(30)

NOT NULL

Created By

srplh_created_date

varchar(30)

NOT NULL

created date

srplh_modified_by

varchar(30)

NULL

Modified By

srplh_modified_date

datetime

NULL

Modified Date

srplh_confirmed_by

varchar(30)

NULL

confirmed by

srplh_confirmed_date

datetime

NULL

confirmed date

srplh_approved_by

varchar(30)

NULL

approved by

srplh_approved_date

datetime

NULL

approved date

spl_skill_price

varchar(25)

NULL

SKILL PRICE : Holds the values " " and "Roster code" Added for RCN : Trn-6S105-Rcn-BasSerPriceList-Rel6-2-01

Table Name spl_srplhH_hdr_Hist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

srplhH_ouinstance

int

NOT NULL

instance from application table

srplhH_plno

varchar(40)

NOT NULL

service pricelist no from application table

srplhH_revno

varchar(40)

NOT NULL

service revision no from application table

srplhH_status

varchar(5)

NOT NULL

status from application table

srplhH_desc

varchar(150)

NOT NULL

desc from application table

srplhH_pl_category

varchar(40)

NULL

category from application table

srplhH_category_ou

int

NULL

category ou from application table

srplhH_eff_from

datetime

NOT NULL

effective date from application table

srplhH_eff_to

datetime

NULL

effectivity date to from application table

srplhH_remarks

varchar(255)

NULL

remarks from application table

srplhH_currency

varchar(20)

NOT NULL

currency from application table

srplhH_oth_currency

varchar(5)

NOT NULL

other currency applicability from application table

srplhH_price_basis

varchar(5)

NOT NULL

price basis from application table

srplhH_std_spl

varchar(40)

NULL

standard spl from application table

srplhH_std_spl_ou

int

NULL

standard spl ou from application table

srplhH_price_factor

numeric

NULL

standard price factor from application table

srplhH_mtrl_cost

varchar(5)

NULL

material cost from application table

SRPLHH_STD_LBR_RATE_NRM

numeric

NULL

standard Normal labour rate from application table

SRPLHH_STD_LBR_RATE_OT

numeric

NULL

standard overtime labour rate from application table

SRPLHH_STD_FAC_RATE

numeric

NULL

standard facility rate from application table

SRPLHH_STD_PPL_NO

varchar(40)

NULL

standard part price list from application table

SRPLHH_STD_PRICING_BASIS

varchar(5)

NULL

standard pricing basis from application table

SRPLHH_STD_PRICING_FACTOR

numeric

NULL

standard pricing factor from application table

SRPLHH_INACTPREVREV

varchar(25)

NULL

inactive revision no from application table

srplhH_file_name

varchar(50)

NULL

file name from application table

srplhH_timestamp

int

NOT NULL

timestamp from application table

srplhH_cancelcomments

varchar(255)

NULL

cancel comments from application table

srplhH_appComments

varchar(255)

NULL

approved comments from application table

srplhH_created_by

varchar(30)

NOT NULL

created by from application table

srplhH_created_date

datetime

NOT NULL

created date from application table

srplhH_modified_by

varchar(30)

NULL

modified by from application table

srplhH_modified_date

datetime

NULL

Modified date from application table

srplhH_confirmed_by

varchar(30)

NULL

confirmed by from application table

srplhH_confirmed_date

datetime

NULL

confirmed date from application table

srplhH_approved_by

varchar(30)

NULL

approved by from application table

srplhH_approved_date

datetime

NULL

approved date from application table

srplhH_revisied_by

varchar(30)

NULL

revised by from application table

srplhH_revisied_date

datetime

NULL

revised date from application table

Table Name spl_srres_res_policy

Table Comment To store the pricing policy of resources of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

SRRES_RATE_PER_HR_NRM

numeric

NULL

resource normal rate /hr

SRRES_RATE_PER_HR_OT

numeric

NULL

resource rate / hr for over time

srres_price_method

varchar(5)

NOT NULL

service price list pricing method values will be direct work unit wise flat

srres_billable

varchar(5)

NOT NULL

billable or not should be given values will be yes or no

srres_resource_ou

int

NULL

resource instance

srres_modified_by

varchar(30)

NULL

modified by

srres_rate_per_hr

numeric

NOT NULL

rate per hour

srres_created_date

datetime

NOT NULL

created date

srres_created_by

varchar(30)

NOT NULL

created by

srres_modified_date

datetime

NULL

modified date

srres_revno

varchar(40)

NOT NULL

service price list revision no

srres_lineno

int

NOT NULL

line no for multi details reference

srres_plno

varchar(40)

NOT NULL

service price list no

srres_ouinstance

int

NOT NULL

repair pricing instance

srres_resource_no

varchar(40)

NULL

resource no

srres_res_type

varchar(5)

NOT NULL

resource type for service price list values will be equipment skills others tools

srplh_ouinstance

int

NULL

service pricelist instance

srplh_revno

varchar(40)

NULL

service pricelist revision no

srplh_plno

varchar(40)

NULL

service pricelist no

Table Name spl_srresH_res_policy_Hist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

srresH_ouinstance

int

NOT NULL

instance from application table

srresH_plno

varchar(40)

NOT NULL

price list from application table

srresH_revno

varchar(40)

NOT NULL

price list revno from application table

srresH_lineno

int

NOT NULL

line no from application table

srresH_res_type

varchar(5)

NOT NULL

resource type from application table

srresH_resource_no

varchar(40)

NULL

resource no  from application table

srresH_resource_ou

int

NULL

resource instance from application table

srresH_billable

varchar(5)

NOT NULL

billable from application table

srresH_price_method

varchar(5)

NOT NULL

price method from application table

SRRESH_RATE_PER_HR_NRM

numeric

NULL

normal rate per hour from application table

SRRESH_RATE_PER_HR_OT

numeric

NULL

over time rate per hour from application table

srresH_created_by

varchar(30)

NOT NULL

created by from application table

srresH_created_date

datetime

NOT NULL

created date from application table

srresH_modified_by

varchar(30)

NULL

modified by from application table

srresH_modified_date

datetime

NULL

modified date from application table

Table Name spl_srvcop_options

Table Comment To store the set options of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

srvcop_OUInstance

int

NOT NULL

instance

srvcop_Activation

varchar(5)

NOT NULL

whether activation of service price list on creation / revision no is to be given values will be like required not required required only for rvns

SRVCOP_BASE_PRTLIST

varchar(40)

NULL

base part price list

srvcop_Timestamp

int

NOT NULL

time stamp for not allowing more than one user to access the same data

srvcop_Created_By

varchar(30)

NOT NULL

created by

srvcop_Created_Date

datetime

NOT NULL

created date

srvcop_Modified_By

varchar(30)

NULL

modified by

srvcop_Modified_Date

datetime

NULL

modified date

srvcop_stksts_req

varchar(5)

NULL

To have the information of stock status is required or not Added for RCN ID : Trn-6S105-Rcn-BasSerPriceList-Rel6-2-01

Table Name spl_wkpr_wkunit_price

Table Comment To store the work unit price of service pricelist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

wkpr_ouinstance

int

NOT NULL

current instance

wkpr_plno

varchar(40)

NOT NULL

service price list no

wkpr_revno

varchar(40)

NOT NULL

revision of service price list no

wkpr_lineno

int

NOT NULL

line no in multiline for work unit

ropr_ouinstance

int

NULL

instance

wkpr_wkunit_ou

int

NOT NULL

work unit instance

wkpr_wkunit_type

varchar(5)

NOT NULL

Type workunit and values will be standard procedure task aircraft work package component Work package Maint change request

wkpr_wkunit_no

varchar(30)

NOT NULL

work unit no

wkpr_mtrl_cost

numeric

NOT NULL

material cost for the work unit

wkpr_res_cost

numeric

NOT NULL

resource cost for the work unit

wkpr_misc_cost

numeric

NULL

miscellaneous cost for work unit

WKPR_FAC_RATE

numeric

NOT NULL

facility rate for work unit

wkpr_auth_units

varchar(256)

NOT NULL

authorizing instance

wkpr_created_by

varchar(30)

NOT NULL

created by

wkpr_created_date

datetime

NOT NULL

created date

wkpr_modified_by

datetime

NULL

modified by

wkpr_modified_date

datetime

NULL

modified date

Table Name spl_wkprH_wkunit_price_Hist

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

wkprH_ouinstance

int

NOT NULL

instance from application table

wkprH_plno

varchar(40)

NOT NULL

plno from application table

wkprH_revno

varchar(40)

NOT NULL

revno from application table

wkprH_lineno

int

NOT NULL

line no from application table

wkprH_wkunit_ou

int

NOT NULL

wrkunit ou from application table

wkprH_wkunit_type

varchar(5)

NOT NULL

wrkunt type from application table

wkprH_wkunit_no

varchar(30)

NOT NULL

wkunitno from application table

wkprH_mtrl_cost

numeric

NOT NULL

material cost from application table

wkprH_res_cost

numeric

NOT NULL

resource cost from application table

wkprH_misc_cost

numeric

NULL

misc cost from application table

WKPRH_FAC_RATE

numeric

NOT NULL

facility rate from application table

wkprH_auth_units

varchar(256)

NOT NULL

auth unit from application table

wkprH_created_by

varchar(30)

NOT NULL

created by from application table

wkprH_created_date

datetime

NOT NULL

created date from application table

wkprH_modified_by

varchar(30)

NULL

modified by from application table

wkprH_modified_date

datetime

NULL

modified date from application table