how to clear up job instances' log more quickly

angela · Post by **angela** » Fri Sep 30, 2005 12:02 am

there are 300 jobs in my project and each job has more than 10 instance. all the jobs only have executable code. i want to clear up all the job instances' log, how should I do?

i know if there is job design, i can run multiple job compile to clear up all job instances' log. however, anyone can help me to find a way to clear up job instances' log in the project only with executable job, it is not one by one but hoped to for a project or a categary.

thanks a lot!

roy · Post by **roy** » Sun Oct 02, 2005 4:17 am

Hi,
Using the search mechanism with "multi instance clear log"
and checking the search for all terms pops up only
this post.

Nothing changed much AFAIK as of today.

IHTH,

ray.wurlod · Post by **ray.wurlod** » Sun Oct 02, 2005 4:43 pm

If you select the base job in Director and choose Clear Log from the job menu it ought to clear all instances. Have not tested this recently, but that's how it used to work.

aartlett · Post by **aartlett** » Mon Oct 03, 2005 12:03 am

I had this problem at my old haunt. Each job that ran had an instance of an unique job id. I found that doing a "Clear Status File" for the base job would delete all instances of the job, but leave the log intact. I also had the clear log of entries over five days set in the Admin of the project.

It took a bit of time, we also had over 300 jobs, but they were split into different catagories, so I would do a new catagory per day and cycle through once every two weeks. This kept things form getting too messy.

I couldn't find anyway to do this automattically, excpet by doing a full system compile (which I did the first time to clean things up after 6 months of neglect).

roy · Post by **roy** » Mon Oct 03, 2005 5:52 pm

If clearing the status file manually helps what about clear.file RT_STATUSnnn?

kduke · Post by **kduke** » Mon Oct 03, 2005 7:01 pm

If you do that then you need to recompile the job. I am sure Ray will give us the full Wurlod.

If you look at the IDs in the RT_STATUS file then you can tell what is a instance id. If you delete those records then you need to disconnect from the project and reconnect to refresh this list.

I think the instance id is also field 7 in the RT_LOG file. You could also delete these records if you wanted to speed things up.

Compiling the job will also clear the instances.

saisen · Post by **saisen** » Thu Oct 06, 2005 11:17 am

Dear all,
I am getting the following compilation error , plz help me if you hv any idea about this.

Thanks,
Senthil
:shock:

=================================
Output from transformer compilation follows:

##I TFCN 000001 16:12:19(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.0.1
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved

##I TUTL 000031 16:12:19(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 16:12:19(002) <main_program> orchgeneral: loaded
##I TOSH 000002 16:12:19(003) <main_program> orchsort: loaded
##I TOSH 000002 16:12:19(004) <main_program> orchstats: loaded
##I TFSC 000001 16:12:19(007) <main_program> APT configuration file: /ds/dsadm/Ascential/DataStage/Configurations/default.apt
##E TBLD 000000 16:12:42(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 10,496
##E TFSR 000019 16:12:42(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 16:12:42(002) <transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
##W TFCP 000025 16:12:42(003) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int16" to result type "String".
##W TFCP 000025 16:12:42(005) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(006) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(007) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(008) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(009) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(010) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(011) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(012) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(013) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(014) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(015) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(016) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(017) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(018) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(019) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(020) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(021) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(022) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(023) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(024) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(025) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(026) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(027) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(028) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(029) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(030) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(031) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(032) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(033) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(034) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(035) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(036) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(037) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(038) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(039) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(040) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(041) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(042) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(043) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(044) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(045) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(046) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(047) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(048) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(049) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(050) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(051) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(052) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(053) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(054) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(055) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(056) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(057) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(058) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(059) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(060) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(061) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(062) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(063) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(064) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(065) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(066) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(067) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(068) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(069) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(070) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(071) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(072) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(073) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(074) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(075) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(076) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(077) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(078) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(079) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(080) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(081) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(082) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(083) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(084) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(085) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(086) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(087) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(088) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(089) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(090) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(091) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(092) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(093) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(094) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(095) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(096) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(097) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(098) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(099) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(100) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(101) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(102) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(103) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(104) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(105) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(106) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(107) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(108) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(109) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(110) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(111) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(112) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(113) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(114) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(115) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(116) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(117) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(118) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(119) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(120) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(121) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(122) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(123) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(124) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(125) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(126) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(127) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(128) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(129) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(130) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(131) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(132) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(133) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(134) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(135) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(136) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TFCP 000025 16:12:42(137) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 16:12:42(138) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 16:12:42(139) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 16:12:42(140) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TBLD 000000 16:12:42(141) <main_program> Error when checking composite operator: Output from subprocess: 1540-5215 (W) No licenses available. Contact your program supplier to add additional users. Compilation will proceed shortly.

##W TBLD 000000 16:12:42(142) <main_program> Error when checking composite operator: Output from subprocess:
storage arena manager: can't satisfy 65504 byte request

##W TBLD 000000 16:12:42(143) <main_program> Error when checking composite operator: Output from subprocess: /usr/vacpp/bin/xlC_r: 1501-230 Internal compiler error; please contact your Service Representative

##I TFCP 000008 16:12:42(144) <transform> Error when checking composite operator: /usr/vacpp/bin/xlC_r -O -I/ds/dsadm/Ascential/DataStage/PXEngine/include -O -c -qspill=32704 /etldata/ifs/IFS_DEV/RT_BP2209.O/V6S1_cp1GL20ValidateQNXTManFields10_xfmQNXTPremiumValidationPart1.C -o /etldata/ifs/IFS_DEV/RT_BP2209.O/V6S1_cp1GL20ValidateQNXTManFields10_xfmQNXTPremiumValidationPart1.tmp.o
##E TCOS 000029 16:12:42(145) <main_program> Creation of step finished with status = FAILED (cp1GL20ValidateQNXTManFields10.xfmQNXTPremiumValidationPart1)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V6S1_cp1GL20ValidateQNXTManFields10_xfmQNXTPremiumValidationPart1 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 inExtract;
0007: outputname 0 inPartialValidated;
0008: outputname 1 inDetailIndicator;
0009: outputname 2 inLineItemIndicator;
0010: outputname 3 inContractNumber;
0011: outputname 4 inProgramType;
0012: outputname 5 inPlanType;
0013: outputname 6 inProgramId;
0014: outputname 7 inEmployerId;
0015: outputname 8 inOrgPolicyId;
0016: outputname 9 inPlanBenefitId;
0017: outputname 10 inPBPNumber;
0018: outputname 11 inRateCodeId;
0019: outputname 12 inCovCodeID;
0020: outputname 13 inGrpVsIndFlag;
0021: outputname 14 inMemNumId;
0022: outputname 15 inMemHICNum;
0023: outputname 16 inMemLastName;
0024: outputname 17 inMemFrtName;
0025: outputname 18 inMemDOB;
0026: outputname 19 inMemGen;
0027: outputname 20 inMemCity;
0028:
0029: global {
0030: // Job parameter declaration
0031: string BatchNum;
0032: string JobNum;
0033: string ErrID;
0034: string AppName;
0035: string DSJobName;
0036: }
0037:
0038: initialize {
0039: // define and initialise our input row count variable
0040: uint64 InRowNumber0;
0041: InRowNumber0 = 0;
0042:
0043: // define our row rejected variable
0044: int8 RowRejected0;
0045:
0046: // define our null set variable
0047: int8 NullSetVar0;
0048:
0049: // define and initialise each link row count variable required
0050: uint64 RowCount0_1;
0051: RowCount0_1 = 0;
0052: uint64 RowCount0_2;
0053: RowCount0_2 = 0;
0054: uint64 RowCount0_3;
0055: RowCount0_3 = 0;
0056: uint64 RowCount0_4;
0057: RowCount0_4 = 0;
0058: uint64 RowCount0_5;
0059: RowCount0_5 = 0;
0060: uint64 RowCount0_6;
0061: RowCount0_6 = 0;
0062: uint64 RowCount0_7;
0063: RowCount0_7 = 0;
0064: uint64 RowCount0_8;
0065: RowCount0_8 = 0;
0066: uint64 RowCount0_9;
0067: RowCount0_9 = 0;
0068: uint64 RowCount0_10;
0069: RowCount0_10 = 0;
0070: uint64 RowCount0_11;
0071: RowCount0_11 = 0;
0072: uint64 RowCount0_12;
0073: RowCount0_12 = 0;
0074: uint64 RowCount0_13;
0075: RowCount0_13 = 0;
0076: uint64 RowCount0_14;
0077: RowCount0_14 = 0;
0078: uint64 RowCount0_15;
0079: RowCount0_15 = 0;
0080: uint64 RowCount0_16;
0081: RowCount0_16 = 0;
0082: uint64 RowCount0_17;
0083: RowCount0_17 = 0;
0084: uint64 RowCount0_18;
0085: RowCount0_18 = 0;
0086: uint64 RowCount0_19;
0087: RowCount0_19 = 0;
0088: uint64 RowCount0_20;
0089: RowCount0_20 = 0;
0090:
0091: // declare our intermediate variables for this section
0092: string InterVar0_0;
0093: string InterVar0_1;
0094: string InterVar0_2;
0095: string InterVar0_3;
0096: string InterVar0_4;
0097: string InterVar0_5;
0098: string InterVar0_6;
0099: string InterVar0_7;
0100: string InterVar0_8;
0101: string InterVar0_9;
0102: string InterVar0_10;
0103: string InterVar0_11;
0104: string InterVar0_12;
0105: string InterVar0_13;
0106: string InterVar0_14;
0107: string InterVar0_15;
0108: string InterVar0_16;
0109: string InterVar0_17;
0110: string InterVar0_18;
0111: string InterVar0_19;
0112: string InterVar0_20;
0113: string InterVar0_21;
0114: string InterVar0_22;
0115: string InterVar0_23;
0116: string InterVar0_24;
0117: string InterVar0_25;
0118: string InterVar0_26;
0119: string InterVar0_27;
0120: string InterVar0_28;
0121: string InterVar0_29;
0122: string InterVar0_30;
0123: string InterVar0_31;
0124: string InterVar0_32;
0125: string InterVar0_33;
0126: string InterVar0_34;
0127: string InterVar0_35;
0128: string InterVar0_36;
0129: string InterVar0_37;
0130: string InterVar0_38;
0131: string InterVar0_39;
0132: string InterVar0_40;
0133: string InterVar0_41;
0134: string InterVar0_42;
0135: string InterVar0_43;
0136: string InterVar0_44;
0137: string InterVar0_46;
0138: string InterVar0_47;
0139: string InterVar0_48;
0140: string InterVar0_49;
0141: string InterVar0_50;
0142: string InterVar0_51;
0143: string InterVar0_52;
0144: string InterVar0_53;
0145: string InterVar0_54;
0146: string InterVar0_55;
0147: string InterVar0_56;
0148: string InterVar0_57;
0149: string InterVar0_58;
0150: string InterVar0_59;
0151: string InterVar0_60;
0152: string InterVar0_61;
0153: string InterVar0_62;
0154: string InterVar0_63;
0155: string InterVar0_64;
0156: string InterVar0_65;
0157: string InterVar0_66;
0158: string InterVar0_67;
0159: string InterVar0_68;
0160: string InterVar0_69;
0161: string InterVar0_70;
0162: string InterVar0_71;
0163: string InterVar0_72;
0164: string InterVar0_73;
0165: string InterVar0_74;
0166: string InterVar0_75;
0167: string InterVar0_76;
0168: string InterVar0_77;
0169: string InterVar0_78;
0170: string InterVar0_79;
0171: string InterVar0_80;
0172: string InterVar0_81;
0173: string InterVar0_82;
0174: string InterVar0_83;
0175: string InterVar0_84;
0176: string InterVar0_85;
0177: string InterVar0_86;
0178: string InterVar0_87;
0179: string InterVar0_88;
0180: string InterVar0_89;
0181: string InterVar0_90;
0182: string InterVar0_91;
0183: string InterVar0_92;
0184: string InterVar0_93;
0185: string InterVar0_94;
0186: string InterVar0_95;
0187: string InterVar0_96;
0188: string InterVar0_97;
0189:
0190: // initialise constant values which require conversion
0191: InterVar0_0 = " ";
0192: InterVar0_1 = "D";
0193: InterVar0_2 = "N";
0194: InterVar0_3 = "Y";
0195: InterVar0_4 = "G";
0196: InterVar0_5 = "I";
0197: InterVar0_6 = "DETAIL_INDICATOR=";
0198: InterVar0_7 = "LINE_ITEM_INDICATOR=";
0199: InterVar0_8 = "CONTRACT_NUMBER=";
0200: InterVar0_9 = "PROGRAM_TYPE =";
0201: InterVar0_10 = "PLAN_TYPE=";
0202: InterVar0_11 = "PROGRAM_ID =";
0203: InterVar0_12 = "EMPLOYER_ID=";
0204: InterVar0_13 = "ORG_POLICY_ID=";
0205: InterVar0_14 = "PLAN_BENEFIT_ID =";
0206: InterVar0_15 = "PBP_NUMBER=";
0207: InterVar0_16 = "RATE_CODE_ID=";
0208: InterVar0_17 = "COVERAGE_CODE_ID=";
0209: InterVar0_18 = "GROUP_VS_IND_FLAG =";
0210: InterVar0_19 = "MEMBER_NUMBER_CARRIER_MEM_ID=";
0211: InterVar0_20 = "MEMBER_HIC_NUMBER=";
0212: InterVar0_21 = "MEMBER_LAST_NAME =";
0213: InterVar0_22 = "MEMBER_FIRST_NAME=";
0214: InterVar0_23 = "MEMBER_DOB=";
0215: InterVar0_24 = "MEMBER_GENDER=";
0216: InterVar0_25 = "MEMBER_CITY =";
0217: InterVar0_26 = "MEMBER_STATE=";
0218: InterVar0_27 = "GROUP_LIS=";
0219: InterVar0_28 = "LIS_STATUS =";
0220: InterVar0_29 = "COPAYMENT_CATEGORY=";
0221: InterVar0_30 = "LIS_FLAG =";
0222: InterVar0_31 = "AR_ACCOUNT_NUMBER =";
0223: InterVar0_32 = "PAYMENT_METHOD =";
0224: InterVar0_33 = "NVOICE_ID=";
0225: InterVar0_34 = "CREATE_DATE=";
0226: InterVar0_35 = "INVOICE_START_DATE=";
0227: InterVar0_36 = "INVOICE_END_DATE =";
0228: InterVar0_37 = "COVERAGE_MONTH=";
0229: InterVar0_38 = "BILLED_MONTH=";
0230: InterVar0_39 = "AMOUNT =";
0231: InterVar0_40 = "INVOICE_TYPE=";
0232: InterVar0_41 = "BILLING_PRODUCT=";
0233: InterVar0_42 = "inExtract";
0234: InterVar0_43 = get_partition_num();
0235: InterVar0_44 = "-";
0236: InterVar0_46 = "-1";
0237: InterVar0_47 = "99999";
0238: InterVar0_48 = "Error in source field DETAIL_INDICATOR";
0239: InterVar0_49 = ": xfmQNXTPremiumValidation";
0240: InterVar0_50 = "DETAIL_INDICATOR= ";
0241: InterVar0_51 = "-2";
0242: InterVar0_52 = "Error in source field LINE_ITEM_INDICATOR";
0243: InterVar0_53 = "-3";
0244: InterVar0_54 = "Error in source field CONTRACT_NUMBER";
0245: InterVar0_55 = "CONTRACT_NUMBER =";
0246: InterVar0_56 = "-4";
0247: InterVar0_57 = "Error in source field PROGRAM_TYPE ";
0248: InterVar0_58 = "-5";
0249: InterVar0_59 = "Error in source field PLAN_TYPE ";
0250: InterVar0_60 = "PLAN_TYPE= ";
0251: InterVar0_61 = "-6";
0252: InterVar0_62 = "Error in source field PROGRAM_ID ";
0253: InterVar0_63 = "PROGRAM_ID=";
0254: InterVar0_64 = "-7";
0255: InterVar0_65 = "Error in source field EMPLOYER_ID ";
0256: InterVar0_66 = "-8";
0257: InterVar0_67 = "Error in source field ORG_POLICY_ID ";
0258: InterVar0_68 = "-9";
0259: InterVar0_69 = "Error in source field PLAN_BENEFIT_ID ";
0260: InterVar0_70 = "PLAN_BENEFIT_ID=";
0261: InterVar0_71 = "-10";
0262: InterVar0_72 = "Error in source field PBP_NUMBER ";
0263: InterVar0_73 = "-11";
0264: InterVar0_74 = "Error in source field RATE_CODE_ID ";
0265: InterVar0_75 = "-12";
0266: InterVar0_76 = "Error in source field COVERAGE_CODE_ID ";
0267: InterVar0_77 = "-13";
0268: InterVar0_78 = "Error in source field GROUP_VS_IND_FLAG ";
0269: InterVar0_79 = "GROUP_VS_IND_FLAG=";
0270: InterVar0_80 = "-14";
0271: InterVar0_81 = "Error in source field MEMBER_NUMBER_CARRIER_MEM_ID";
0272: InterVar0_82 = "MEMBER_NUMBER_CARRIER_MEM_ID =";
0273: InterVar0_83 = "-15";
0274: InterVar0_84 = "Error in source field MEMBER_HIC_NUMBER";
0275: InterVar0_85 = "MEMBER_HIC_NUMBER =";
0276: InterVar0_86 = "-16";
0277: InterVar0_87 = "Error in source field MEMBER_LAST_NAME ";
0278: InterVar0_88 = "MEMBER_LAST_NAME=";
0279: InterVar0_89 = "-17";
0280: InterVar0_90 = "Error in source field MEMBER_FIRST_NAME";
0281: InterVar0_91 = "-18";
0282: InterVar0_92 = "Error in source field MEMBER_DOB ";
0283: InterVar0_93 = "-19";
0284: InterVar0_94 = "Error in source field MEMBER_GENDER";
0285: InterVar0_95 = "-20";
0286: InterVar0_96 = "Error in source field MEMBER_CITY";
0287: InterVar0_97 = "MEMBER_CITY=";
0288: // Stage variable declaration and initialisation
0289: string StageVar0_svDetailIndicator;
0290: StageVar0_svDetailIndicator = "";
0291: string StageVar0_svLineItemIndicator;
0292: StageVar0_svLineItemIndicator = "";
0293: string StageVar0_svContractNumber;
0294: StageVar0_svContractNumber = "";
0295: string StageVar0_svProgramType;
0296: StageVar0_svProgramType = "";
0297: string StageVar0_svPlanType;
0298: StageVar0_svPlanType = "";
0299: string StageVar0_svProgramID;
0300: StageVar0_svProgramID = "";
0301: string StageVar0_svEmployerID;
0302: StageVar0_svEmployerID = "";
0303: string StageVar0_svOrgPolicyID;
0304: StageVar0_svOrgPolicyID = "";
0305: string StageVar0_svPlanBenefitID;
0306: StageVar0_svPlanBenefitID = "";
0307: string StageVar0_svPBPNumber;
0308: StageVar0_svPBPNumber = "";
0309: string StageVar0_svRateCodeID;
0310: StageVar0_svRateCodeID = "";
0311: string StageVar0_svCoverageCodeID;
0312: StageVar0_svCoverageCodeID = "";
0313: string StageVar0_svGroupVsIndFlag;
0314: StageVar0_svGroupVsIndFlag = "";
0315: string StageVar0_svMemberNumberID;
0316: StageVar0_svMemberNumberID = "";
0317: string StageVar0_svMemberHICNumber;
0318: StageVar0_svMemberHICNumber = "";
0319: string StageVar0_svMemberLastName;
0320: StageVar0_svMemberLastName = "";
0321: string StageVar0_svMemberFirstName;
0322: StageVar0_svMemberFirstName = "";
0323: string StageVar0_svMemberDOB;
0324: StageVar0_svMemberDOB = "";
0325: string StageVar0_svMemberGender;
0326: StageVar0_svMemberGender = "";
0327: string StageVar0_svMemberCity;
0328: StageVar0_svMemberCity = "";
0329: string StageVar0_svMemberState;
0330: StageVar0_svMemberState = "";
0331: string StageVar0_svGroupLIS;
0332: StageVar0_svGroupLIS = "";
0333: string StageVar0_svLISStatus;
0334: StageVar0_svLISStatus = "";
0335: string StageVar0_svCopaymentCategory;
0336: StageVar0_svCopaymentCategory = "";
0337: string StageVar0_svLISFlag;
0338: StageVar0_svLISFlag = "";
0339: string StageVar0_svSourceValues;
0340: StageVar0_svSourceValues = "";
0341: string StageVar0_svValidFieldsPart1;
0342: StageVar0_svValidFieldsPart1 = "";
0343: }
0344:
0345: mainloop {
0346: // initialise our row rejected variable
0347: RowRejected0 = 1;
0348:
0349: // increment our input row count
0350: InRowNumber0 = InRowNumber0 + 1;
0351:
0352: // declare our intermediate variables for this section
0353: string InterVar0_45;
0354:
0355: // evaluate the stage variables first
0356: if (((null(inExtract.DETAIL_INDICATOR) || (trimc_string(inExtract.DETAIL_INDICATOR) == InterVar0_0)) || (trimc_string(inExtract.DETAIL_INDICATOR) != InterVar0_1))) {
0357: StageVar0_svDetailIndicator = InterVar0_2;
0358: } else {
0359: StageVar0_svDetailIndicator = InterVar0_3;
0360: }
0361: //;
0362: if ((null(inExtract.LINE_ITEM_INDICATOR) || (trimc_string(inExtract.LINE_ITEM_INDICATOR) == InterVar0_0))) {
0363: StageVar0_svLineItemIndicator = InterVar0_2;
0364: } else {
0365: StageVar0_svLineItemIndicator = InterVar0_3;
0366: }
0367: //;
0368: if ((null(inExtract.CONTRACT_NUMBER) || (trimc_string(inExtract.CONTRACT_NUMBER) == InterVar0_0))) {
0369: StageVar0_svContractNumber = InterVar0_2;
0370: } else {
0371: StageVar0_svContractNumber = InterVar0_3;
0372: }
0373: //;
0374: if ((null(inExtract.PROGRAM_TYPE) || (trimc_string(inExtract.PROGRAM_TYPE) == InterVar0_0))) {
0375: StageVar0_svProgramType = InterVar0_2;
0376: } else {
0377: StageVar0_svProgramType = InterVar0_3;
0378: }
0379: //;
0380: if ((null(inExtract.PLAN_TYPE) || (trimc_string(inExtract.PLAN_TYPE) == InterVar0_0))) {
0381: StageVar0_svPlanType = InterVar0_2;
0382: } else {
0383: StageVar0_svPlanType = InterVar0_3;
0384: }
0385: //;
0386: if (((null(inExtract.PROGRAM_ID) || (trimc_string(inExtract.PROGRAM_ID) == InterVar0_0)) || (trimc_string(inExtract.PROGRAM_ID) != InterVar0_1))) {
0387: StageVar0_svProgramID = InterVar0_2;
0388: } else {
0389: StageVar0_svProgramID = InterVar0_3;
0390: }
0391: //;
0392: if ((null(inExtract.EMPLOYER_ID) || (trimc_string(inExtract.EMPLOYER_ID) == InterVar0_0))) {
0393: StageVar0_svEmployerID = InterVar0_2;
0394: } else {
0395: StageVar0_svEmployerID = InterVar0_3;
0396: }
0397: //;
0398: if ((null(inExtract.ORG_POLICY_ID) || (trimc_string(inExtract.ORG_POLICY_ID) == InterVar0_0))) {
0399: StageVar0_svOrgPolicyID = InterVar0_2;
0400: } else {
0401: StageVar0_svOrgPolicyID = InterVar0_3;
0402: }
0403: //;
0404: if ((null(inExtract.PLAN_BENEFIT_ID) || (trimc_string(inExtract.PLAN_BENEFIT_ID) == InterVar0_0))) {
0405: StageVar0_svPlanBenefitID = InterVar0_2;
0406: } else {
0407: StageVar0_svPlanBenefitID = InterVar0_3;
0408: }
0409: //;
0410: if ((null(inExtract.PBP_NUMBER) || (trimc_string(inExtract.PBP_NUMBER) == InterVar0_0))) {
0411: StageVar0_svPBPNumber = InterVar0_2;
0412: } else {
0413: StageVar0_svPBPNumber = InterVar0_3;
0414: }
0415: //;
0416: if ((null(inExtract.RATE_CODE_ID) || (trimc_string(inExtract.RATE_CODE_ID) == InterVar0_0))) {
0417: StageVar0_svRateCodeID = InterVar0_2;
0418: } else {
0419: StageVar0_svRateCodeID = InterVar0_3;
0420: }
0421: //;
0422: if ((null(inExtract.COVERAGE_CODE_ID) || (trimc_string(inExtract.COVERAGE_CODE_ID) == InterVar0_0))) {
0423: StageVar0_svCoverageCodeID = InterVar0_2;
0424: } else {
0425: StageVar0_svCoverageCodeID = InterVar0_3;
0426: }
0427: //;
0428: if ((((null(inExtract.GROUP_VS_IND_FLAG) || (trimc_string(inExtract.GROUP_VS_IND_FLAG) == InterVar0_0)) || (trimc_string(inExtract.GROUP_VS_IND_FLAG) != InterVar0_4)) || (trimc_string(inExtract.GROUP_VS_IND_FLAG) != InterVar0_5))) {
0429: StageVar0_svGroupVsIndFlag = InterVar0_2;
0430: } else {
0431: StageVar0_svGroupVsIndFlag = InterVar0_3;
0432: }
0433: //;
0434: if ((null(inExtract.MEMBER_NUMBER_CARRIER_MEM_ID) || (trimc_string(inExtract.MEMBER_NUMBER_CARRIER_MEM_ID) == InterVar0_0))) {
0435: StageVar0_svMemberNumberID = InterVar0_2;
0436: } else {
0437: StageVar0_svMemberNumberID = InterVar0_3;
0438: }
0439: //;
0440: if ((null(inExtract.MEMBER_HIC_NUMBER) || (trimc_string(inExtract.MEMBER_HIC_NUMBER) == InterVar0_0))) {
0441: StageVar0_svMemberHICNumber = InterVar0_2;
0442: } else {
0443: StageVar0_svMemberHICNumber = InterVar0_3;
0444: }
0445: //;
0446: if ((null(inExtract.MEMBER_LAST_NAME) || (trimc_string(inExtract.MEMBER_LAST_NAME) == InterVar0_0))) {
0447: StageVar0_svMemberLastName = InterVar0_2;
0448: } else {
0449: StageVar0_svMemberLastName = InterVar0_3;
0450: }
0451: //;
0452: if ((null(inExtract.MEMBER_FIRST_NAME) || (trimc_string(inExtract.MEMBER_FIRST_NAME) == InterVar0_0))) {
0453: StageVar0_svMemberFirstName = InterVar0_2;
0454: } else {
0455: StageVar0_svMemberFirstName = InterVar0_3;
0456: }
0457: //;
0458: if ((null(inExtract.MEMBER_DOB) || (trimc_string(inExtract.MEMBER_DOB) == InterVar0_0))) {
0459: StageVar0_svMemberDOB = InterVar0_2;
0460: } else {
0461: StageVar0_svMemberDOB = InterVar0_3;
0462: }
0463: //;
0464: if ((null(inExtract.MEMBER_GENDER) || (trimc_string(inExtract.MEMBER_GENDER) == InterVar0_0))) {
0465: StageVar0_svMemberGender = InterVar0_2;
0466: } else {
0467: StageVar0_svMemberGender = InterVar0_3;
0468: }
0469: //;
0470: if ((null(inExtract.MEMBER_CITY) || (trimc_string(inExtract.MEMBER_CITY) == InterVar0_0))) {
0471: StageVar0_svMemberCity = InterVar0_2;
0472: } else {
0473: StageVar0_svMemberCity = InterVar0_3;
0474: }
0475: //;
0476: if ((null(inExtract.MEMBER_STATE) || (trimc_string(inExtract.MEMBER_STATE) == InterVar0_0))) {
0477: StageVar0_svMemberState = InterVar0_2;
0478: } else {
0479: StageVar0_svMemberState = InterVar0_3;
0480: }
0481: //;
0482: if ((null(inExtract.GROUP_LIS) || (trimc_string(inExtract.GROUP_LIS) == InterVar0_0))) {
0483: StageVar0_svGroupLIS = InterVar0_2;
0484: } else {
0485: StageVar0_svGroupLIS = InterVar0_3;
0486: }
0487: //;
0488: if ((null(inExtract.LIS_STATUS) || (trimc_string(inExtract.LIS_STATUS) == InterVar0_0))) {
0489: StageVar0_svLISStatus = InterVar0_2;
0490: } else {
0491: StageVar0_svLISStatus = InterVar0_3;
0492: }
0493: //;
0494: if (((null(inExtract.COPAYMENT_CATEGORY) || (trimc_string(inExtract.COPAYMENT_CATEGORY) == InterVar0_0)) || (trimc_string(inExtract.COPAYMENT_CATEGORY) != InterVar0_1))) {
0495: StageVar0_svCopaymentCategory = InterVar0_2;
0496: } else {
0497: StageVar0_svCopaymentCategory = InterVar0_3;
0498: }
0499: //;
0500: if ((null(inExtract.LIS_FLAG) || (trimc_string(inExtract.LIS_FLAG) == InterVar0_0))) {
0501: StageVar0_svLISFlag = InterVar0_2;
0502: } else {
0503: StageVar0_svLISFlag = InterVar0_3;
0504: }
0505: //;
0506: StageVar0_svSourceValues = left_substring((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((InterVar0_6 + inExtract.DETAIL_INDICATOR) + InterVar0_7) + inExtract.LINE_ITEM_INDICATOR) + InterVar0_8) + inExtract.CONTRACT_NUMBER) + InterVar0_9) + inExtract.PROGRAM_TYPE) + InterVar0_10) + inExtract.PLAN_TYPE) + InterVar0_11) + inExtract.PROGRAM_ID) + InterVar0_12) + inExtract.EMPLOYER_ID) + InterVar0_13) + inExtract.ORG_POLICY_ID) + InterVar0_14) + inExtract.PLAN_BENEFIT_ID) + InterVar0_15) + inExtract.PBP_NUMBER) + InterVar0_16) + inExtract.RATE_CODE_ID) + InterVar0_17) + inExtract.COVERAGE_CODE_ID) + InterVar0_18) + inExtract.GROUP_VS_IND_FLAG) + InterVar0_19) + inExtract.MEMBER_NUMBER_CARRIER_MEM_ID) + InterVar0_20) + inExtract.MEMBER_HIC_NUMBER) + InterVar0_21) + inExtract.MEMBER_LAST_NAME) + InterVar0_22) + inExtract.MEMBER_FIRST_NAME) + InterVar0_23) + inExtract.MEMBER_DOB) + InterVar0_24) + inExtract.MEMBER_GENDER) + InterVar0_25) + inExtract.MEMBER_CITY) + InterVar0_26) + inExtract.MEMBER_STATE) + InterVar0_27) + inExtract.GROUP_LIS) + InterVar0_28) + inExtract.LIS_STATUS) + InterVar0_29) + inExtract.COPAYMENT_CATEGORY) + InterVar0_30) + inExtract.LIS_FLAG) + InterVar0_31) + inExtract.AR_ACCOUNT_NUMBER) + InterVar0_32) + inExtract.PAYMENT_METHOD) + InterVar0_33) + inExtract.INVOICE_ID) + InterVar0_34) + inExtract.CREATE_DATE) + InterVar0_35) + inExtract.INVOICE_START_DATE) + InterVar0_36) + inExtract.INVOICE_END_DATE) + InterVar0_37) + inExtract.COVERAGE_MONTH) + InterVar0_38) + inExtract.BILLED_MONTH) + InterVar0_39) + inExtract.AMOUNT) + InterVar0_40) + inExtract.INVOICE_TYPE) + InterVar0_41) + inExtract.BILLING_PRODUCT) , 2000);
0507: if ((((((((((((((((((((((((((StageVar0_svDetailIndicator == InterVar0_3) && (StageVar0_svLineItemIndicator == InterVar0_3)) && (StageVar0_svContractNumber == InterVar0_3)) && (StageVar0_svProgramType == InterVar0_3)) && (StageVar0_svPlanType == InterVar0_3)) && (StageVar0_svProgramID == InterVar0_3)) && (StageVar0_svEmployerID == InterVar0_3)) && (StageVar0_svOrgPolicyID == InterVar0_3)) && (StageVar0_svPlanBenefitID == InterVar0_3)) && (StageVar0_svPBPNumber == InterVar0_3)) && (StageVar0_svRateCodeID == InterVar0_3)) && (StageVar0_svCoverageCodeID == InterVar0_3)) && (StageVar0_svGroupVsIndFlag == InterVar0_3)) && (StageVar0_svMemberNumberID == InterVar0_3)) && (StageVar0_svMemberHICNumber == InterVar0_3)) && (StageVar0_svMemberLastName == InterVar0_3)) && (StageVar0_svMemberFirstName == InterVar0_3)) && (StageVar0_svMemberDOB == InterVar0_3)) && (StageVar0_svMemberGender == InterVar0_3)) && (StageVar0_svMemberCity == InterVar0_3)) && (StageVar0_svMemberState == InterVar0_3)) && (StageVar0_svGroupLIS == InterVar0_3)) && (StageVar0_svLISStatus == InterVar0_3)) && (StageVar0_svCopaymentCategory == InterVar0_3)) && (StageVar0_svLISFlag == InterVar0_3))) {
0508: StageVar0_svValidFieldsPart1 = InterVar0_3;
0509: } else {
0510: StageVar0_svValidFieldsPart1 = InterVar0_2;
0511: }
0512: //;
0513:
0514: // evaluate constraint and columns for link: inPartialValidated
0515: if ((StageVar0_svValidFieldsPart1 == InterVar0_3))
0516: {
0517: inPartialValidated.DETAIL_INDICATOR = inExtract.DETAIL_INDICATOR;
0518: inPartialValidated.LINE_ITEM_INDICATOR = inExtract.LINE_ITEM_INDICATOR;
0519: inPartialValidated.CONTRACT_NUMBER = inExtract.CONTRACT_NUMBER;
0520: inPartialValidated.PROGRAM_TYPE = inExtract.PROGRAM_TYPE;
0521: inPartialValidated.PLAN_TYPE = inExtract.PLAN_TYPE;
0522: inPartialValidated.PROGRAM_ID = inExtract.PROGRAM_ID;
0523: inPartialValidated.PROGRAM_NAME = inExtract.PROGRAM_NAME;
0524: inPartialValidated.EMPLOYER_ID = inExtract.EMPLOYER_ID;
0525: inPartialValidated.EMPLOYER_NAME = inExtract.EMPLOYER_NAME;
0526: inPartialValidated.ORG_POLICY_ID = inExtract.ORG_POLICY_ID;
0527: inPartialValidated.ORG_POLICY_NAME = inExtract.ORG_POLICY_NAME;
0528: inPartialValidated.PLAN_BENEFIT_ID = inExtract.PLAN_BENEFIT_ID;
0529: inPartialValidated.PLAN_BENEFIT_NAME = inExtract.PLAN_BENEFIT_NAME;
0530: inPartialValidated.PBP_NUMBER = inExtract.PBP_NUMBER;
0531: inPartialValidated.RIDER_ID = inExtract.RIDER_ID;
0532: inPartialValidated.RIDER_NAME = inExtract.RIDER_NAME;
0533: inPartialValidated.RATE_CODE_ID = inExtract.RATE_CODE_ID;
0534: inPartialValidated.RATE_CODE_DESCRIPTION = inExtract.RATE_CODE_DESCRIPTION;
0535: inPartialValidated.COVERAGE_CODE_ID = inExtract.COVERAGE_CODE_ID;
0536: inPartialValidated.COVERAGE_CODE_DESCRIPTION = inExtract.COVERAGE_CODE_DESCRIPTION;
0537: inPartialValidated.GROUP_VS_IND_FLAG = inExtract.GROUP_VS_IND_FLAG;
0538: inPartialValidated.MEMBER_NUMBER_CARRIER_MEM_ID = inExtract.MEMBER_NUMBER_CARRIER_MEM_ID;
0539: inPartialValidated.MEMBER_HIC_NUMBER = inExtract.MEMBER_HIC_NUMBER;
0540: inPartialValidated.MEMBER_LAST_NAME = inExtract.MEMBER_LAST_NAME;
0541: inPartialValidated.MEMBER_FIRST_NAME = inExtract.MEMBER_FIRST_NAME;
0542: inPartialValidated.MEMBER_MIDDLE_INITIAL = inExtract.MEMBER_MIDDLE_INITIAL;
0543: inPartialValidated.MEMBER_DOB = inExtract.MEMBER_DOB;
0544: inPartialValidated.MEMBER_GENDER = inExtract.MEMBER_GENDER;
0545: inPartialValidated.MEMBER_CITY = inExtract.MEMBER_CITY;
0546: inPartialValidated.MEMBER_COUNTY = inExtract.MEMBER_COUNTY;
0547: inPartialValidated.MEMBER_STATE = inExtract.MEMBER_STATE;
0548: inPartialValidated.MEMBER_RISK_ADJUSTMENT_FACTOR = inExtract.MEMBER_RISK_ADJUSTMENT_FACTOR;
0549: inPartialValidated.MEMBER_HEALTH_FACTOR_1 = inExtract.MEMBER_HEALTH_FACTOR_1;
0550: inPartialValidated.MEMBER_HEALTH_FACTOR_2 = inExtract.MEMBER_HEALTH_FACTOR_2;
0551: inPartialValidated.MEMBER_HEALTH_FACTOR_3 = inExtract.MEMBER_HEALTH_FACTOR_3;
0552: inPartialValidated.MEMBER_HEALTH_FACTOR_4 = inExtract.MEMBER_HEALTH_FACTOR_4;
0553: inPartialValidated.MEMBER_HEALTH_FACTOR_5 = inExtract.MEMBER_HEALTH_FACTOR_5;
0554: inPartialValidated.MEMBER_HEALTH_FACTOR_6 = inExtract.MEMBER_HEALTH_FACTOR_6;
0555: inPartialValidated.MEMBER_HEALTH_FACTOR_7 = inExtract.MEMBER_HEALTH_FACTOR_7;
0556: inPartialValidated.MEMBER_HEALTH_FACTOR_8 = inExtract.MEMBER_HEALTH_FACTOR_8;
0557: inPartialValidated.MEMBER_HEALTH_FACTOR_9 = inExtract.MEMBER_HEALTH_FACTOR_9;
0558: inPartialValidated.MEMBER_HEALTH_FACTOR_10 = inExtract.MEMBER_HEALTH_FACTOR_10;
0559: inPartialValidated.GROUP_LIS = inExtract.GROUP_LIS;
0560: inPartialValidated.LIS_STATUS = inExtract.LIS_STATUS;
0561: inPartialValidated.COPAYMENT_CATEGORY = inExtract.COPAYMENT_CATEGORY;
0562: inPartialValidated.LIS_FLAG = inExtract.LIS_FLAG;
0563: inPartialValidated.INSTITUTIONAL_FLAG = inExtract.INSTITUTIONAL_FLAG;
0564: inPartialValidated.AR_ACCOUNT_NUMBER = inExtract.AR_ACCOUNT_NUMBER;
0565: inPartialValidated.PAYMENT_METHOD = inExtract.PAYMENT_METHOD;
0566: inPartialValidated.BANK_ACCOUNT = inExtract.BANK_ACCOUNT;
0567: inPartialValidated.INVOICE_ID = inExtract.INVOICE_ID;
0568: inPartialValidated.CREATE_DATE = inExtract.CREATE_DATE;
0569: inPartialValidated.INVOICE_START_DATE = inExtract.INVOICE_START_DATE;
0570: inPartialValidated.INVOICE_END_DATE = inExtract.INVOICE_END_DATE;
0571: inPartialValidated.COVERAGE_MONTH = inExtract.COVERAGE_MONTH;
0572: inPartialValidated.BILLED_MONTH = inExtract.BILLED_MONTH;
0573: inPartialValidated.AMOUNT = inExtract.AMOUNT;
0574: inPartialValidated.INVOICE_TYPE = inExtract.INVOICE_TYPE;
0575: inPartialValidated.BILLING_PRODUCT = inExtract.BILLING_PRODUCT;
0576: inPartialValidated.ADJUSTMENT_REASON_TYPE = inExtract.ADJUSTMENT_REASON_TYPE;
0577: inPartialValidated.REASON_CODE = inExtract.REASON_CODE;
0578: inPartialValidated.REASON_CODE_DESCRIPTION = inExtract.REASON_CODE_DESCRIPTION;
0579: inPartialValidated.CASH_RECEIPT_NUMBER = inExtract.CASH_RECEIPT_NUMBER;
0580: inPartialValidated.DOCUMENT_NUMBER = inExtract.DOCUMENT_NUMBER;
0581: inPartialValidated.ADJUSTMENT_ID = inExtract.ADJUSTMENT_ID;
0582: inPartialValidated.VOID_DATE = inExtract.VOID_DATE;
0583: inPartialValidated.DEPOSIT_DATE = inExtract.DEPOSIT_DATE;
0584: inPartialValidated.RF1 = inExtract.RF1;
0585: inPartialValidated.RF2 = inExtract.RF2;
0586: inPartialValidated.RF3 = inExtract.RF3;
0587: inPartialValidated.Source_Values = StageVar0_svSourceValues;
0588: writerecord 0;
0589: RowRejected0 = 0;
0590: }
0591: // evaluate constraint and columns for link: inDetailIndicator
0592: if ((StageVar0_svDetailIndicator == InterVar0_2))
0593: {
0594: inDetailIndicator.LinkName = InterVar0_42;
0595: InterVar0_45 = (RowCount0_1 + 1);
0596: inDetailIndicator.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_46);
0597: inDetailIndicator.BatchNum = BatchNum;
0598: inDetailIndicator.Job_Nbr = JobNum;
0599: inDetailIndicator.Error_ID = ErrID;
0600: inDetailIndicator.Rec_Num = InRowNumber0;
0601: inDetailIndicator.Err_Code = InterVar0_47;
0602: inDetailIndicator.App_Name = AppName;
0603: inDetailIndicator.Err_Desc = InterVar0_48;
0604: inDetailIndicator.Err_Src = (DSJobName + InterVar0_49);
0605: inDetailIndicator.Err_Data = (InterVar0_50 + inExtract.DETAIL_INDICATOR);
0606: inDetailIndicator.Source_Values = StageVar0_svSourceValues;
0607: writerecord 1;
0608: RowRejected0 = 0;
0609: RowCount0_1 = RowCount0_1 + 1;
0610: }
0611: // evaluate constraint and columns for link: inLineItemIndicator
0612: if ((StageVar0_svLineItemIndicator == InterVar0_2))
0613: {
0614: inLineItemIndicator.LinkName = InterVar0_42;
0615: InterVar0_45 = (RowCount0_2 + 1);
0616: inLineItemIndicator.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_51);
0617: inLineItemIndicator.BatchNum = BatchNum;
0618: inLineItemIndicator.Job_Nbr = JobNum;
0619: inLineItemIndicator.Error_ID = ErrID;
0620: inLineItemIndicator.Rec_Num = InRowNumber0;
0621: inLineItemIndicator.Err_Code = InterVar0_47;
0622: inLineItemIndicator.App_Name = AppName;
0623: inLineItemIndicator.Err_Desc = InterVar0_52;
0624: inLineItemIndicator.Err_Src = (DSJobName + InterVar0_49);
0625: inLineItemIndicator.Err_Data = (InterVar0_7 + inExtract.LINE_ITEM_INDICATOR);
0626: inLineItemIndicator.Source_Values = StageVar0_svSourceValues;
0627: writerecord 2;
0628: RowRejected0 = 0;
0629: RowCount0_2 = RowCount0_2 + 1;
0630: }
0631: // evaluate constraint and columns for link: inContractNumber
0632: if ((StageVar0_svContractNumber == InterVar0_2))
0633: {
0634: inContractNumber.LinkName = InterVar0_42;
0635: InterVar0_45 = (RowCount0_3 + 1);
0636: inContractNumber.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_53);
0637: inContractNumber.BatchNum = BatchNum;
0638: inContractNumber.Job_Nbr = JobNum;
0639: inContractNumber.Error_ID = ErrID;
0640: inContractNumber.Rec_Num = InRowNumber0;
0641: inContractNumber.Err_Code = InterVar0_47;
0642: inContractNumber.App_Name = AppName;
0643: inContractNumber.Err_Desc = InterVar0_54;
0644: inContractNumber.Err_Src = (DSJobName + InterVar0_49);
0645: inContractNumber.Err_Data = (InterVar0_55 + inExtract.CONTRACT_NUMBER);
0646: inContractNumber.Source_Values = StageVar0_svSourceValues;
0647: writerecord 3;
0648: RowRejected0 = 0;
0649: RowCount0_3 = RowCount0_3 + 1;
0650: }
0651: // evaluate constraint and columns for link: inProgramType
0652: if ((StageVar0_svProgramType == InterVar0_2))
0653: {
0654: inProgramType.LinkName = InterVar0_42;
0655: InterVar0_45 = (RowCount0_4 + 1);
0656: inProgramType.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_56);
0657: inProgramType.BatchNum = BatchNum;
0658: inProgramType.Job_Nbr = JobNum;
0659: inProgramType.Error_ID = ErrID;
0660: inProgramType.Rec_Num = InRowNumber0;
0661: inProgramType.Err_Code = InterVar0_47;
0662: inProgramType.App_Name = AppName;
0663: inProgramType.Err_Desc = InterVar0_57;
0664: inProgramType.Err_Src = (DSJobName + InterVar0_49);
0665: inProgramType.Err_Data = (InterVar0_9 + inExtract.PROGRAM_TYPE);
0666: inProgramType.Source_Values = StageVar0_svSourceValues;
0667: writerecord 4;
0668: RowRejected0 = 0;
0669: RowCount0_4 = RowCount0_4 + 1;
0670: }
0671: // evaluate constraint and columns for link: inPlanType
0672: if ((StageVar0_svProgramID == InterVar0_2))
0673: {
0674: inPlanType.LinkName = InterVar0_42;
0675: InterVar0_45 = (RowCount0_5 + 1);
0676: inPlanType.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_58);
0677: inPlanType.BatchNum = BatchNum;
0678: inPlanType.Job_Nbr = JobNum;
0679: inPlanType.Error_ID = ErrID;
0680: inPlanType.Rec_Num = InRowNumber0;
0681: inPlanType.Err_Code = InterVar0_47;
0682: inPlanType.App_Name = AppName;
0683: inPlanType.Err_Desc = InterVar0_59;
0684: inPlanType.Err_Src = (DSJobName + InterVar0_49);
0685: inPlanType.Err_Data = (InterVar0_60 + inExtract.PLAN_TYPE);
0686: inPlanType.Source_Values = StageVar0_svSourceValues;
0687: writerecord 5;
0688: RowRejected0 = 0;
0689: RowCount0_5 = RowCount0_5 + 1;
0690: }
0691: // evaluate constraint and columns for link: inProgramId
0692: if ((StageVar0_svProgramID == InterVar0_2))
0693: {
0694: inProgramId.LinkName = InterVar0_42;
0695: InterVar0_45 = (RowCount0_6 + 1);
0696: inProgramId.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_61);
0697: inProgramId.BatchNum = BatchNum;
0698: inProgramId.Job_Nbr = JobNum;
0699: inProgramId.Error_ID = ErrID;
0700: inProgramId.Rec_Num = InRowNumber0;
0701: inProgramId.Err_Code = InterVar0_47;
0702: inProgramId.App_Name = AppName;
0703: inProgramId.Err_Desc = InterVar0_62;
0704: inProgramId.Err_Src = (DSJobName + InterVar0_49);
0705: inProgramId.Err_Data = (InterVar0_63 + inExtract.PROGRAM_ID);
0706: inProgramId.Source_Values = StageVar0_svSourceValues;
0707: writerecord 6;
0708: RowRejected0 = 0;
0709: RowCount0_6 = RowCount0_6 + 1;
0710: }
0711: // evaluate constraint and columns for link: inEmployerId
0712: if ((StageVar0_svEmployerID == InterVar0_2))
0713: {
0714: inEmployerId.LinkName = InterVar0_42;
0715: InterVar0_45 = (RowCount0_7 + 1);
0716: inEmployerId.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_64);
0717: inEmployerId.BatchNum = BatchNum;
0718: inEmployerId.Job_Nbr = JobNum;
0719: inEmployerId.Error_ID = ErrID;
0720: inEmployerId.Rec_Num = InRowNumber0;
0721: inEmployerId.Err_Code = InterVar0_47;
0722: inEmployerId.App_Name = AppName;
0723: inEmployerId.Err_Desc = InterVar0_65;
0724: inEmployerId.Err_Src = (DSJobName + InterVar0_49);
0725: inEmployerId.Err_Data = (InterVar0_12 + inExtract.EMPLOYER_ID);
0726: inEmployerId.Source_Values = StageVar0_svSourceValues;
0727: writerecord 7;
0728: RowRejected0 = 0;
0729: RowCount0_7 = RowCount0_7 + 1;
0730: }
0731: // evaluate constraint and columns for link: inOrgPolicyId
0732: if ((StageVar0_svOrgPolicyID == InterVar0_2))
0733: {
0734: inOrgPolicyId.LinkName = InterVar0_42;
0735: InterVar0_45 = (RowCount0_8 + 1);
0736: inOrgPolicyId.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_66);
0737: inOrgPolicyId.BatchNum = BatchNum;
0738: inOrgPolicyId.Job_Nbr = JobNum;
0739: inOrgPolicyId.Error_ID = ErrID;
0740: inOrgPolicyId.Rec_Num = InRowNumber0;
0741: inOrgPolicyId.Err_Code = InterVar0_47;
0742: inOrgPolicyId.App_Name = AppName;
0743: inOrgPolicyId.Err_Desc = InterVar0_67;
0744: inOrgPolicyId.Err_Src = (DSJobName + InterVar0_49);
0745: inOrgPolicyId.Err_Data = (InterVar0_13 + inExtract.ORG_POLICY_ID);
0746: inOrgPolicyId.Source_Values = StageVar0_svSourceValues;
0747: writerecord 8;
0748: RowRejected0 = 0;
0749: RowCount0_8 = RowCount0_8 + 1;
0750: }
0751: // evaluate constraint and columns for link: inPlanBenefitId
0752: if ((StageVar0_svPlanBenefitID == InterVar0_2))
0753: {
0754: inPlanBenefitId.LinkName = InterVar0_42;
0755: InterVar0_45 = (RowCount0_9 + 1);
0756: inPlanBenefitId.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_68);
0757: inPlanBenefitId.BatchNum = BatchNum;
0758: inPlanBenefitId.Job_Nbr = JobNum;
0759: inPlanBenefitId.Error_ID = ErrID;
0760: inPlanBenefitId.Rec_Num = InRowNumber0;
0761: inPlanBenefitId.Err_Code = InterVar0_47;
0762: inPlanBenefitId.App_Name = AppName;
0763: inPlanBenefitId.Err_Desc = InterVar0_69;
0764: inPlanBenefitId.Err_Src = (DSJobName + InterVar0_49);
0765: inPlanBenefitId.Err_Data = (InterVar0_70 + inExtract.PLAN_BENEFIT_ID);
0766: inPlanBenefitId.Source_Values = StageVar0_svSourceValues;
0767: writerecord 9;
0768: RowRejected0 = 0;
0769: RowCount0_9 = RowCount0_9 + 1;
0770: }
0771: // evaluate constraint and columns for link: inPBPNumber
0772: if ((StageVar0_svPBPNumber == InterVar0_2))
0773: {
0774: inPBPNumber.LinkName = InterVar0_42;
0775: InterVar0_45 = (RowCount0_10 + 1);
0776: inPBPNumber.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_71);
0777: inPBPNumber.BatchNum = BatchNum;
0778: inPBPNumber.Job_Nbr = JobNum;
0779: inPBPNumber.Error_ID = ErrID;
0780: inPBPNumber.Rec_Num = InRowNumber0;
0781: inPBPNumber.Err_Code = InterVar0_47;
0782: inPBPNumber.App_Name = AppName;
0783: inPBPNumber.Err_Desc = InterVar0_72;
0784: inPBPNumber.Err_Src = (DSJobName + InterVar0_49);
0785: inPBPNumber.Err_Data = (InterVar0_15 + inExtract.PBP_NUMBER);
0786: inPBPNumber.Source_Values = StageVar0_svSourceValues;
0787: writerecord 10;
0788: RowRejected0 = 0;
0789: RowCount0_10 = RowCount0_10 + 1;
0790: }
0791: // evaluate constraint and columns for link: inRateCodeId
0792: if ((StageVar0_svRateCodeID == InterVar0_2))
0793: {
0794: inRateCodeId.LinkName = InterVar0_42;
0795: InterVar0_45 = (RowCount0_11 + 1);
0796: inRateCodeId.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_73);
0797: inRateCodeId.BatchNum = BatchNum;
0798: inRateCodeId.Job_Nbr = JobNum;
0799: inRateCodeId.Error_ID = ErrID;
0800: inRateCodeId.Rec_Num = InRowNumber0;
0801: inRateCodeId.Err_Code = InterVar0_47;
0802: inRateCodeId.App_Name = AppName;
0803: inRateCodeId.Err_Desc = InterVar0_74;
0804: inRateCodeId.Err_Src = (DSJobName + InterVar0_49);
0805: inRateCodeId.Err_Data = (InterVar0_16 + inExtract.RATE_CODE_ID);
0806: inRateCodeId.Source_Values = StageVar0_svSourceValues;
0807: writerecord 11;
0808: RowRejected0 = 0;
0809: RowCount0_11 = RowCount0_11 + 1;
0810: }
0811: // evaluate constraint and columns for link: inCovCodeID
0812: if ((StageVar0_svCoverageCodeID == InterVar0_2))
0813: {
0814: inCovCodeID.LinkName = InterVar0_42;
0815: InterVar0_45 = (RowCount0_12 + 1);
0816: inCovCodeID.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_75);
0817: inCovCodeID.BatchNum = BatchNum;
0818: inCovCodeID.Job_Nbr = JobNum;
0819: inCovCodeID.Error_ID = ErrID;
0820: inCovCodeID.Rec_Num = InRowNumber0;
0821: inCovCodeID.Err_Code = InterVar0_47;
0822: inCovCodeID.App_Name = AppName;
0823: inCovCodeID.Err_Desc = InterVar0_76;
0824: inCovCodeID.Err_Src = (DSJobName + InterVar0_49);
0825: inCovCodeID.Err_Data = (InterVar0_17 + inExtract.COVERAGE_CODE_ID);
0826: inCovCodeID.Source_Values = StageVar0_svSourceValues;
0827: writerecord 12;
0828: RowRejected0 = 0;
0829: RowCount0_12 = RowCount0_12 + 1;
0830: }
0831: // evaluate constraint and columns for link: inGrpVsIndFlag
0832: if ((StageVar0_svGroupVsIndFlag == InterVar0_2))
0833: {
0834: inGrpVsIndFlag.LinkName = InterVar0_42;
0835: InterVar0_45 = (RowCount0_13 + 1);
0836: inGrpVsIndFlag.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_77);
0837: inGrpVsIndFlag.BatchNum = BatchNum;
0838: inGrpVsIndFlag.Job_Nbr = JobNum;
0839: inGrpVsIndFlag.Error_ID = ErrID;
0840: inGrpVsIndFlag.Rec_Num = InRowNumber0;
0841: inGrpVsIndFlag.Err_Code = InterVar0_47;
0842: inGrpVsIndFlag.App_Name = AppName;
0843: inGrpVsIndFlag.Err_Desc = InterVar0_78;
0844: inGrpVsIndFlag.Err_Src = (DSJobName + InterVar0_49);
0845: inGrpVsIndFlag.Err_Data = (InterVar0_79 + inExtract.GROUP_VS_IND_FLAG);
0846: inGrpVsIndFlag.Source_Values = StageVar0_svSourceValues;
0847: writerecord 13;
0848: RowRejected0 = 0;
0849: RowCount0_13 = RowCount0_13 + 1;
0850: }
0851: // evaluate constraint and columns for link: inMemNumId
0852: if ((StageVar0_svMemberNumberID == InterVar0_2))
0853: {
0854: inMemNumId.LinkName = InterVar0_42;
0855: InterVar0_45 = (RowCount0_14 + 1);
0856: inMemNumId.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_80);
0857: inMemNumId.BatchNum = BatchNum;
0858: inMemNumId.Job_Nbr = JobNum;
0859: inMemNumId.Error_ID = ErrID;
0860: inMemNumId.Rec_Num = InRowNumber0;
0861: inMemNumId.Err_Code = InterVar0_47;
0862: inMemNumId.App_Name = AppName;
0863: inMemNumId.Err_Desc = InterVar0_81;
0864: inMemNumId.Err_Src = (DSJobName + InterVar0_49);
0865: inMemNumId.Err_Data = (InterVar0_82 + inExtract.MEMBER_NUMBER_CARRIER_MEM_ID);
0866: inMemNumId.Source_Values = StageVar0_svSourceValues;
0867: writerecord 14;
0868: RowRejected0 = 0;
0869: RowCount0_14 = RowCount0_14 + 1;
0870: }
0871: // evaluate constraint and columns for link: inMemHICNum
0872: if ((StageVar0_svMemberHICNumber == InterVar0_2))
0873: {
0874: inMemHICNum.LinkName = InterVar0_42;
0875: InterVar0_45 = (RowCount0_15 + 1);
0876: inMemHICNum.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_83);
0877: inMemHICNum.BatchNum = BatchNum;
0878: inMemHICNum.Job_Nbr = JobNum;
0879: inMemHICNum.Error_ID = ErrID;
0880: inMemHICNum.Rec_Num = InRowNumber0;
0881: inMemHICNum.Err_Code = InterVar0_47;
0882: inMemHICNum.App_Name = AppName;
0883: inMemHICNum.Err_Desc = InterVar0_84;
0884: inMemHICNum.Err_Src = (DSJobName + InterVar0_49);
0885: inMemHICNum.Err_Data = (InterVar0_85 + inExtract.MEMBER_HIC_NUMBER);
0886: inMemHICNum.Source_Values = StageVar0_svSourceValues;
0887: writerecord 15;
0888: RowRejected0 = 0;
0889: RowCount0_15 = RowCount0_15 + 1;
0890: }
0891: // evaluate constraint and columns for link: inMemLastName
0892: if ((StageVar0_svMemberLastName == InterVar0_2))
0893: {
0894: inMemLastName.LinkName = InterVar0_42;
0895: InterVar0_45 = (RowCount0_16 + 1);
0896: inMemLastName.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_86);
0897: inMemLastName.BatchNum = BatchNum;
0898: inMemLastName.Job_Nbr = JobNum;
0899: inMemLastName.Error_ID = ErrID;
0900: inMemLastName.Rec_Num = InRowNumber0;
0901: inMemLastName.Err_Code = InterVar0_47;
0902: inMemLastName.App_Name = AppName;
0903: inMemLastName.Err_Desc = InterVar0_87;
0904: inMemLastName.Err_Src = (DSJobName + InterVar0_49);
0905: inMemLastName.Err_Data = (InterVar0_88 + inExtract.MEMBER_LAST_NAME);
0906: inMemLastName.Source_Values = StageVar0_svSourceValues;
0907: writerecord 16;
0908: RowRejected0 = 0;
0909: RowCount0_16 = RowCount0_16 + 1;
0910: }
0911: // evaluate constraint and columns for link: inMemFrtName
0912: if ((StageVar0_svMemberFirstName == InterVar0_2))
0913: {
0914: inMemFrtName.LinkName = InterVar0_42;
0915: InterVar0_45 = (RowCount0_17 + 1);
0916: inMemFrtName.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_89);
0917: inMemFrtName.BatchNum = BatchNum;
0918: inMemFrtName.Job_Nbr = JobNum;
0919: inMemFrtName.Error_ID = ErrID;
0920: inMemFrtName.Rec_Num = InRowNumber0;
0921: inMemFrtName.Err_Code = InterVar0_47;
0922: inMemFrtName.App_Name = AppName;
0923: inMemFrtName.Err_Desc = InterVar0_90;
0924: inMemFrtName.Err_Src = (DSJobName + InterVar0_49);
0925: inMemFrtName.Err_Data = (InterVar0_22 + inExtract.MEMBER_FIRST_NAME);
0926: inMemFrtName.Source_Values = StageVar0_svSourceValues;
0927: writerecord 17;
0928: RowRejected0 = 0;
0929: RowCount0_17 = RowCount0_17 + 1;
0930: }
0931: // evaluate constraint and columns for link: inMemDOB
0932: if ((StageVar0_svMemberDOB == InterVar0_2))
0933: {
0934: inMemDOB.LinkName = InterVar0_42;
0935: InterVar0_45 = (RowCount0_18 + 1);
0936: inMemDOB.RowNum = (((InterVar0_43 + InterVar0_44) + InterVar0_45) + InterVar0_91);
0937: inMemDOB.BatchNum = BatchNum;
0938: inMemDOB.Job_Nbr = JobNum;
0939: inMemDOB.Error_ID = ErrID;
0940: inMemDOB.Rec_Num = InRowNumber0;
0941: inMemDOB.Err_Code = InterVar0_47;
0942: inMemDOB.App_Name = AppName;
0943: inMemDOB.Err_Desc = InterVar0_92;
0944: i

ray.wurlod · Post by **ray.wurlod** » Thu Oct 06, 2005 4:39 pm

Only if you explain in what way your post relates to the topic of this thread.

We do not answer questions posted on hijacked threads. Start a new thread.