OHConstant

public interface  OHConstants
{
        public static final String INITIAL_CONTEXT_FACTORY="weblogic.jndi.WLInitialContextFactory";
        public static final String PROVIDER_URL="t3://sa235:7001";
        public static final String HOST_NAME_PORT="sa235:7001";

        /**
         *
         * Screen Modes
         */
        public static final String MODIFY   ="MODIFY";
        public static final String SEARCH   ="SEARCH";
        public static final String ENTER    ="ENTER";
        public static final String REENTER  ="REENTER";
        public static final String ENTER_HOS    ="ENTER_HOS";
        public static final String REENTER_HOS  ="REENTER_HOS";
        public static final String VERIFY   ="VERIFY";
        public static final String VIEW     ="VIEW";
        public static final String VIEW_REENTER     ="VIEW_REENTER";
        public static final String VERIFIED ="VERIFIED";
        public static final String APPROVED ="APPROVED";
        public static final String REJECTED ="REJECTED";
        public static final String SAVED    ="SAVED";
        public static final String CANCELLED="CANCELLED";
        public static final String COMPLETED="COMPLETED";
        public static final String SAVED_AS_REJECTED="SAVED_AS_REJECTED";
        public static final String APPROVE_LEVEL_1="APPROVE1";
        public static final String APPROVE_LEVEL_2="APPROVE2";
        public static final String APPROVE_LEVEL_3="APPROVE3";
        public static final String APPROVE_LEVEL_4="APPROVE4";
        public static final String APPROVE_LEVEL_5="APPROVE5";
        public static final String APPROVE ="APPROVE";
        public static final String QUERY ="true";

        public static final String NEXT ="NEXT";
        public static final String PREVIOUS ="PREVIOUS";

        /* Addition for date Entry Format*/
        public static final String HIJRAH="H";
        public static final String GREGORIAN="G";
        public static final String DEFAULT_ENT_FMT="H";
        public static final String INVALID_ENT_FMT="I";

        /* Addition Begins - JYO - 07/02/2002 for Companion */
        public static final String APPROVE_OH_DOCTOR="APPROVE_OH_DOC";
        public static final String APPROVE_OH_DOC="APPROVE_OH_DOC";
        public static final String APPROVE_OH_HEAD="APPROVE_OH_HEAD";
        public static final String APPROVE_FO_DIR="APPROVE_FO_DIR";
        public static final String APPROVE_GOVERNER="APPROVE_GOV";
        public static final String APPROVE_INT_AUD_HEAD="APPROVE_INT_AUD_HEAD";
        /*Theese were found missing and added by Kiran on 4/3/2002 12:40 PM */
        public static final String APPROVE_PMB_SECY="APPROVE_PMB_SECY";
        public static final String APPROVE_AMB_SECY="APPROVE_AMB_SECY";
        public static final String APPROVE_SOC_AFFAIRS="APPROVE_SOC_AFFAIRS";
        public static final String APPROVE_FIN_SEC_MGR="APPROVE_FIN_SEC_MGR";
        public static final String APPROVE_SI_DIR="APPROVE_SI_DIR";


        // Hospital List that allow to him use upload services
       /* public static final Long []  HOSPITAL_LIST_UPLOAD_SERVICES={new Long("503537788"),
            new Long("10001501"),new Long("13224315"),new Long("110078609"),new Long("500641738"),
            new Long("200017439"),new Long("502455710"),new Long("200068211"),new Long("100000199"),
            new Long("100013266"),new Long("250107463"),new Long("210012508"),new Long("503433125")};*/

        //public static final Long []  HOSPITAL_LIST_UPLOAD_SERVICES={};


//T_INJURY
        //This status corresponds to notified....
        //Status of an Injury  used in T_INJURY Table. DB FIELD - INJURYSTATUS.
        public static final Short INJ_STS_FIRST_NOTIFIED = new Short("1000");
        public static final Short INJ_STS_CURED_WITHOUT_DISABILITY=new Short("1001");
        public static final Short INJ_STS_CURED_WITH_DISABILITY=new Short("1002");
        public static final Short INJ_STS_EXTENSION_REQUIRED=new Short("1003");
        public static final Short INJ_STS_RESULTED_IN_DEATH=new Short("1004");
                public static final Short INJ_STS_TRANSFERED=new Short("1005");
        //This Status is actually ENTERED not notified....
        public static final Short INJ_STS_NOTIFIED=new Short("1006");
        public static final Short INJ_STS_APPROVED=new Short("1007");
        public static final Short INJ_STS_COMPLETED=new Short("1008");
        public static final Short INJ_STS_REJECTED=new Short("1009");
        public static final Short INJ_STS_TRANSFERED_DISEASE=new Short("1010");
                public static final Short INJ_STS_CANCELLED=new Short("1011");
                public static final Short INJ_STS_CANCLLED_BY_SYSTEM=new Short("1012");

        /*Table - T_INJURY DB FIELD - WORKFLOWSTATUS*/
        public static final Short WFS_INJ_PENDING_DATA_ENTRY=new Short("1000");
        public static final Short WFS_INJ_ENTERED=new Short("1001");
        public static final Short WFS_INJ_VERIFIED=new Short("1002");
        public static final Short WFS_INJ_APPROVED_SUPERVISOR =new Short("1003");
        public static final Short WFS_INJ_APPROVED_OH_DOC=new Short("1004");
        public static final Short WFS_INJ_APPROVED_PMB_DOC=new Short("1005");
        public static final Short WFS_INJ_APPROVED_OH_HEAD=new Short("1006");
        public static final Short WFS_INJ_APPROVED_FO_DIR=new Short("1007");
        public static final Short WFS_INJ_APPROVED_GVNR=new Short("1008");
        public static final Short WFS_INJ_REJECTED_OH_DOC=new Short("1009");
        public static final Short WFS_INJ_REJECTED_PMB_DOC=new Short("1010");
        public static final Short WFS_INJ_REJECTED_OH_HEAD=new Short("1011");
        public static final Short WFS_INJ_REJECTED_FO_DIR=new Short("1012");
        public static final Short WFS_INJ_REJECTED_GVNR=new Short("1013");
        public static final Short WFS_INJ_REJECTED=new Short("1014");
        public static final Short WFS_INJ_REJECTED_SUPERVISOR =new Short("1015");
        public static final Short WFS_INJ_CANCELLED_CLERK=new Short("1016");
        public static final Short WFS_INJ_CANCELLED_SUPERVISOR =new Short("1017");
        public static final Short WFS_INJ_CANCELLED_OH_DOC=new Short("1018");
        public static final Short WFS_INJ_CANCELLED_PMB_DOC=new Short("1019");
        public static final Short WFS_INJ_CANCELLED_OH_HEAD=new Short("1020");
        public static final Short WFS_INJ_CANCELLED_FO_DIR=new Short("1021");
        public static final Short WFS_INJ_CANCELLED_GVNR=new Short("1022");
        public static final Short WFS_INJ_APPROVED_HO_DOC =new Short("1023");
        public static final Short WFS_INJ_APPROVED_AMB_DOC =new Short("1024");
        public static final Short WFS_INJ_REJECTED_HO_DOC =new Short("1025");
        public static final Short WFS_INJ_REJECTED_AMB_DOC =new Short("1026");
        public static final Short WFS_INJ_CANCELLED_HO_DOC =new Short("1027");
        public static final Short WFS_INJ_CANCELLED_AMB_DOC =new Short("1028");
        public static final Short WFS_INJ_APPROVED_SA_MED =new Short("1029");
        public static final Short WFS_INJ_REJECTED_SA_MED =new Short("1030");
        public static final Short WFS_INJ_CANCELLED_SA_MED =new Short("1031");
        public static final Short WFS_INJ_APPROVED_SA_LEG =new Short("1032");
        public static final Short WFS_INJ_REJECTED_SA_LEG =new Short("1033");
        public static final Short WFS_INJ_CANCELLED_SA_LEG =new Short("1034");
        public static final Short WFS_INJ_APPROVED_DY_GOV =new Short("1035");
        public static final Short WFS_INJ_REJECTED_DY_GOV =new Short("1036");
        public static final Short WFS_INJ_CANCELLED_DY_GOV =new Short("1037");
        public static final Short WFS_INJ_REJECT_OH_INJURY_IN_WF = new Short("1038");
        public static final Short WFS_INJ_APPROVE_INT_AUD_CLK = new Short("1039");
        public static final Short WFS_INJ_APPROVE_INT_AUD_HEAD = new Short("1040");
        public static final Short WFS_INJ_REJECT_INT_AUD_CLK = new Short("1041");
        public static final Short WFS_INJ_REJECT_INT_AUD_HEAD = new Short("1042");
        /*Four Main workflow status of an injury
        Table - T_INJURY DB FIELD - WORKFLOWSTATUS*/
        public static final Short WFS_INJ_CURED_WITH_DISB_WF =new Short("1050");
        public static final Short WFS_INJ_CURED_WITHOUT_DISB_WF =new Short("1051");
        public static final Short WFS_INJ_RESULTED_IN_DEATH_WF =new Short("1052");
        public static final Short WFS_INJ_TRMT_EXTENDED_WF = new Short("1053");
                public static final Short WFS_INJ_CANCLLED_BY_SYSTEM = new Short("1054");

                public static final Long MTN_INJ_COMPLN = new Long("101527");
                public static final Long MNT_INJURY = new Long("101501");


        /* Receiving wage from employer in T_INJURY Table. DB FIELD - RECEIVINGWAGEFROMEMP*/
        /*This field specifies if contributor is receiving wage from employer.*/
        public static final Byte RECEIVING_WAGE_FROM_EMP_YES = new Byte("1"); //Contributor receives wage from employer
        public static final Byte RECEIVING_WAGE_FROM_EMP_NO = new Byte("0"); //Contributor does not receive wage from employer

        /* Initiated User type in T_INJURY Table. DB FIELD - INITIATEDBY*/
        /*This field specifies who initiated the injury.*/
        public static final Short INITIATEDBY_ESTABLISHMENT = new Short("2001"); //Initiated by Establishment users
        public static final Short INITIATEDBY_FIELDOFFICE = new Short("2002"); //Initiated by Field office users
        public static final Short INITIATEDBY_HOSPITAL = new Short("2003"); //Initiated by Hospital users

        /* Entered User type in T_INJURY Table. DB FIELD - ENTEREDBY*/
        /*This field specifies who entered the injury.*/
        public static final Short ENTEREDBY_ESTABLISHMENT = new Short("2001"); //Entered by Establishment users
        public static final Short ENTEREDBY_FIELDOFFICE   = new Short("2002"); //Entered by Field office users
        public static final Short ENTEREDBY_HOSPITAL      = new Short("2003");  //Entered by Hospital users

        /* Government Sector Type in T_INJURY Table. DB FIELD - GOVERNMENTSECTOR*/
        /*This field specifies who was present at the scene of the injury.*/
        public static final Short TRAFFIC_DEPARTMENT = new Short("1001");
        public static final Short POLICE             = new Short("1002");
        public static final Short FIRE_DEPARTMET     = new Short("1003");

        //what kind of treatment is given to contributor during his injury in T_INJURY Table. DB FIELD - LINEOFTRMT.
        public static final Short INJ_LINE_OF_TRMT_OTHERS = new Short("1001");
        public static final Short INJ_LINE_OF_TRMT_CLINICAL=new Short("1002");
        public static final Short INJ_LINE_OF_TRMT_SURGICAL=new Short("1003");

        /* Type of injury in T_INJURY Table. DB FIELD - INJURYTYPE*/
        public static final Byte INJ_TYPE_INJURY=new Byte("0");
        public static final Byte INJ_TYPE_DISEASE=new Byte("1");

        /* RejectionCode in T_INJURY */
        public static final Short INJ_RTC_REJECTED_AND_GOSI_PAY=new Short("1008"); //Rejected and GOSI will pay the Hospital Treatment only
        public static final Short INJ_RTC_REJECTED_PASS_MONTH_WITHOUT_RESPONSE=new Short("1045"); //Rejected Because Passing a month on workflow without response from Employers
        public static final Short INJ_RTC_REJECTED_EST_STOPPED_PAYING_CONTRIBUTION=new Short("1043"); //Rejected Because Establishment has stopped paying contribution

        public static final Short OTHER_OF_ACCIDENT = new Short("899");
        public static final Short OTHER_OF_INJURY_SOURCE = new Short("9800");
        public static final Short OTHER_OF_INJURY_NATURE = new Short("995");

        /* Type of injury in T_INJURY Table. DB FIELD - SICKLEAVEFLAG*/
        public static final Byte INJ_CAN_ENTER_SCIKLEAVE_PERIOD=new Byte("0");
        public static final Byte INJ_CAN_NOT_ENTER_SCIKLEAVE_PERIOD=new Byte("1");


//T_TREATMENT
        //Status for TreatmentPeriod used in T_TREATMENT Table. - DB field is TREATMENTSTATUS.
        public static final Short TRMT_STS_ENTERED      = new Short("1000");        //  TreatmentStatusEntered
        public static final Short TRMT_STS_CONTINUING   = new Short("1001");        //  TreatmentStatusContinuing
        public static final Short TRMT_STS_COMPLETED    = new Short("1002");        //  TreatmentStatusCompleted
        public static final Short TRMT_STS_APPROVED     = new Short("1003");        //  TreatmentStatusApproved
        public static final Short TRMT_STS_REJECTED     = new Short("1004");        //  TreatmentStatusRejected
        public static final Short TRMT_STS_CANCELLED    = new Short("1005");        //  TreatmentStatusCancelled
        public static final Short TRMT_STS_OVERLAPPED    =new Short("1006");        //  TreatmentStatusOverlapped

        //Types of treatment used in T_TREATMENT Table. - DB field is TREATMENTTYPE
        public static final Short TRMT_TYPE_INPATIENT = new Short("1001");
        public static final Short TRMT_TYPE_SICKLEAVE = new Short("1002");
        public static final Short TRMT_TYPE_OUTPATIENT = new Short("1003");

        //Types of treatment used in T_TRTMSERVICELISTHEADER Table. - DB field is TRANSACTIONTYPE
        public static final Short TRTM_TYPE_NEW = new Short("1001");
        public static final Short TRTM_TYPE_OLD = new Short("1002");
        public static final Short TRTM_TYPE_MODIFY = new Short("1002");

        //Types of treatment used in T_TRTMSERVICELISTDETAILS Table. - DB field is NEEDSAPPROVAL
        public static final Short TRTM_NEEDSAPPROVAL_NO_NEED = new Short("1000");
        public static final Short TRTM_NEEDSAPPROVAL_NEED = new Short("1001");

      //Types of treatment used in T_TRTMSERVICELISTDETAILS Table. - DB field is IS
        public static final Byte TRTM_ISNONDISCOUNT_NO = new Byte("0");
        public static final Byte TRTM_ISNONDISCOUNT_YES = new Byte("1");


        //Headquarter office location code
        public static final short HQ_LOCATION_CODE = 0;

        //Workflow status for treatment service list header used in T_TRTRMSERVICELISTHEADER Table. - DB field is WORKFLOWSTATUS
        public static final Short WFS_TRTM_SRVC_LIST_HDR_PENDING_DATA_ENTRY   = new Short("1000");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_ENTERED              = new Short("1001");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_VERIFIED             = new Short("1002");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_APPROVED_DOCTOR      = new Short("1003");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_APPROVED_FO_DIR      = new Short("1004");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_REJECTED             = new Short("1005");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_REJECTED_DOCTOR      = new Short("1006");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_REJECTED_FO_DIR      = new Short("1007");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_CANCELLED            = new Short("1008");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_APPROVED_AUD_CLK     = new Short("1009");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_REJECTED_AUD_CLK     = new Short("1010");
        public static final Short WFS_TRTM_SRVC_LIST_HDR_REENTERED              = new Short("1011");

        //Status for treatment service list detail used in T_TRTRMSERVICELISTDETAIL Table. - DB field is STATUS
        public static final Short TRTM_SRVC_LIST_DET_STATUS_ENTERED           = new Short("1000");
        public static final Short TRTM_SRVC_LIST_DET_STATUS_VERIFIED          = new Short("1001");
        public static final Short TRTM_SRVC_LIST_DET_STATUS_REJECTED          = new Short("1002");
        public static final Short TRTM_SRVC_LIST_DET_STATUS_APPROVED1         = new Short("1003");
        public static final Short TRTM_SRVC_LIST_DET_STATUS_APPROVED          = new Short("1004");
        public static final Short TRTM_SRVC_LIST_DET_STATUS_CANCELLED         = new Short("1005");
        public static final Short TRTM_SRVC_LIST_DET_STATUS_SAVED_AS_REJECTED = new Short("1006");
        public static final Short TRTM_SRVC_LIST_DET_STATUS_APPROVED2         = new Short("1007");

        //Workflow status for TreatmentPeriod used in T_TREATMENT Table. - DB field is WORKFLOWSTATUS.
        public static final Short WFS_TRMT_PENDING_DATA_ENTRY = new Short("1000");
        public static final Short WFS_TRMT_ENTERED  = new Short("1001");
        public static final Short WFS_TRMT_VERIFIED = new Short("1002");
        public static final Short WFS_TRMT_APPROVED_SUPERVISOR = new Short("1003");
        public static final Short WFS_TRMT_REJECTED_SUPERVISOR = new Short("1004");
        public static final Short WFS_TRMT_APPROVED_OH_DOC  = new Short("1005");
        public static final Short WFS_TRMT_REJECTED_OH_DOC  = new Short("1006");
        public static final Short WFS_TRMT_VERIFIED_OH_DOC  = new Short("1007");
        public static final Short WFS_TRMT_APPROVED_OH_HEAD = new Short("1008");
        public static final Short WFS_TRMT_REJECTED_OH_HEAD = new Short("1009");
        public static final Short WFS_TRMT_REJECTED = new Short("1010");
        public static final Short WFS_TRMT_CANCELLED = new Short("1011");
        public static final Short WFS_TRMT_APPROVED_OH_CLERK    = new Short("1012");
        public static final Short WFS_TRMT_REJECTED_OH_CLERK    = new Short("1013");
        public static final Short WFS_TRMT_OVERLAPPED   = new Short("1014");

//T_TRMTEXTENSION
        /* Treatment Extension Status used in T_TRMTEXTENSION Table. DB FIELD - EXTENSIONSTATUS. */
        public static final Short EXTN_STS_ENTERED = new Short("1001");
        public static final Short EXTN_STS_APPROVED = new Short("1002");
        public static final Short EXTN_STS_REJECTED = new Short("1003");
        public static final Short EXTN_STS_CANCELLED = new Short("1004");

//T_OHSICKLEAVE
        /* Treatment Extension Status used in T_OHSICKLEAVE Table. DB FIELD - EXTENSIONSTATUS. */
        public static final Short EXTN_SICKLEAVE_STS_ENTERED = new Short("1001");
        public static final Short EXTN_SICKLEAVE_STS_APPROVED = new Short("1002");
        public static final Short EXTN_SICKLEAVE_STS_REJECTED = new Short("1003");
        public static final Short EXTN_SICKLEAVE_STS_CANCELLED = new Short("1004");

        /* Treatment Extension Status used in T_OHSICKLEAVE Table. DB FIELD - ISNEEDSICKLEAVE. */
        public static final Byte EXTN_SICKLEAVE_IS_NOT_NEED_SICKLEAVE=new Byte("0");
        public static final Byte EXTN_SICKLEAVE_IS_NEED_SICKLEAVE=new Byte("1");

        /* reason code for why period not Generated */
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_NO_ECLAIM  =new Short("1000");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_NO_CLOSUER=new Short("1001");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_ECLAIM_FILE_HAVE_ERROR=new Short("1002");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_NOT_ECLAIM_UPDATED=new Short("1003");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_INJ_REJECTED=new Short("1004");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_INJ_ENTERED=new Short("1005");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_PENDING_WF_EXTENSION=new Short("1006");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_PENDING_WF_TRANSFER=new Short("1007");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_PENDING_WF_PERIOD=new Short("1008");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_WAIT_BATCH_RUN=new Short("1009");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_PENDING_WF_SICKLEAVE=new Short("1010");
        public static final Short EXTN_SICKLEAVE_REASON_PERIOD_NOT_GENERATED_PENDING_WF_SERVICE=new Short("1011");




        // Treatment Extension Workflow Status used in T_TRMTEXTENSION Table. DB FIELD - WORKFLOWSTATUS.
        public static final Short WFS_EXTN_ENTERED = new Short("1001");
        public static final Short WFS_EXTN_VERIFIED = new Short("1002");
        public static final Short WFS_EXTN_REJECTED_OH_SUPERVISOR = new Short("1003");
        public static final Short WFS_EXTN_APPROVED_OH_DOC = new Short("1004");
        public static final Short WFS_EXTN_REJECTED_OH_DOC = new Short("1005");
        public static final Short WFS_EXTN_APPROVED_OH_HEAD = new Short("1006");
        public static final Short WFS_EXTN_REJECTED_OH_HEAD = new Short("1007");
        public static final Short WFS_EXTN_APPROVED_PMB_DOC = new Short("1008");
        public static final Short WFS_EXTN_REJECTED_PMB_DOC = new Short("1009");
        public static final Short WFS_EXTN_REJECTED = new Short("1010");
        public static final Short WFS_EXTN_CANCELLED = new Short("1011");
        public static final Short WFS_EXTN_APPROVED_HQ_DOC=new Short("1012");
        public static final Short WFS_EXTN_REJECTED_HQ_DOC=new Short("1013");
        public static final Short WFS_EXTN_APPROVED_AMB_DOC=new Short("1014");
        public static final Short WFS_EXTN_REJECTED_AMB_DOC=new Short("1015");
        public static final Short WFS_EXTN_APPROVED_SADIR_MED=new Short("1016");
        public static final Short WFS_EXTN_REJECTED_SADIR_MED=new Short("1017");
        public static final Short WFS_EXTN_APPROVED_FO_DIR=new Short("1018");
        public static final Short WFS_EXTN_REJECTED_FO_DIR=new Short("1019");
        public static final Short WFS_EXTN_APPROVED_SADIR_LEG=new Short("1020");
        public static final Short WFS_EXTN_REJECTED_SADIR_LEG=new Short("1021");
        public static final Short WFS_EXTN_APPROVED_DY_GOV=new Short("1022");
        public static final Short WFS_EXTN_REJECTED_DY_GOV=new Short("1023");
        public static final Short WFS_EXTN_APPROVED_GOV=new Short("1024");
        public static final Short WFS_EXTN_REJECTED_GOV=new Short("1025");
        public static final Short WFS_EXTN_APPROVED_INT_AUD_CLK=new Short("1026");
        public static final Short WFS_EXTN_REJECTED_INT_AUD_CLK=new Short("1027");
        public static final Short WFS_EXTN_APPROVED_INT_AUD_MGR=new Short("1028");
        public static final Short WFS_EXTN_REJECTED_INT_AUD_MGR=new Short("1029");
        public static final Short WFS_EXTN_ENTERD_WITH_TREATMENT = new Short("1030");   //  Workflowstaus Extension Entered with Treatment.
        public static final Short WFS_EXTN_ENTERD_WITH_SICKLEAVE = new Short("1031");   //  Workflowstaus Extension Entered with Treatment.
        public static final Short CLS_EXT_OHD_REQ_REJ=new Short("1000");

// T_TRMTSERVICEREQUESTAPPROVAL
        /* Treatment service request Status used in T_TRMTSERVICEREQUESTAPPROVAL Table. DB FIELD - REQUESTSTATUS. */
        public static final Short TRMT_REQ_ENTERED = new Short("1001");
        public static final Short TRMT_REQ_APPROVED = new Short("1002");
        public static final Short TRMT_REQ_REJECTED = new Short("1003");
        public static final Short TRMT_REQ_CANCELLED = new Short("1004");

        // /* Treatment service request Status used in T_TRMTSERVICEREQUESTAPPROVAL Table. DB FIELD - UNCODEDSERVICE. */
        public static final Short TRMT_REQ_MRI_CT = new Short("1001");
        public static final Short TRMT_REQ_DENTAL_COMBINATIONS = new Short("1002");
        public static final Short TRMT_REQ_EYEGLASSES = new Short("1003");
        public static final Short TRMT_REQ_AID_APPLIANCE = new Short("1004");
        public static final Short TRMT_REQ_PHYSIOTHERAPHY_MEETINGS = new Short("1005");
        public static final Short TRMT_REQ_SUPERVISION_DOCTOR_VISITS_SITUATION = new Short("1006");
        public static final Short TRMT_REQ_OPERATIONS_SLIDE_DISCS = new Short("1007");
        public static final Short TRMT_REQ_COSMETIC = new Short("1008");
        public static final Short TRMT_REQ_MEDICINES_DESCRIBED_MORE_DAYS = new Short("1009");
        public static final Short TRMT_REQ_CONDITIONS_CAUSE_TRACING_DURING_STAY_HOS = new Short("1010");

//T_COMPANION
        /* Type of the companion in T_COMPANION Table. DB FIELD - TYPEOFCOMP */
        public static final Byte COMP_TYPE_DOCTOR = new Byte("1");
        public static final Byte COMP_TYPE_NURSE  = new Byte("2");
        public static final Byte COMP_TYPE_OTHERS = new Byte("3");

        /*Companion status in T_COMPANION Table. DB FIELD  - STATUS */
        public static final Short COMP_STS_ENTERED  = new Short("1001") ;
        public static final Short COMP_STS_VERIFIED = new Short("1002") ;
        public static final Short COMP_STS_APPROVED = new Short("1003") ;
        public static final Short COMP_STS_REJECTED = new Short("1004") ;
        public static final Short COMP_STS_CANCELLED = new Short("1005") ;

        /*workflow status of companion in T_COMPANION Table. DB FIELD  - WORKFLOWSTATUS */
        public static final Short WFS_COMP_ENTERED = new Short("1001") ;
        public static final Short WFS_COMP_VERIFIED = new Short("1002") ;
        public static final Short WFS_COMP_REJECTED = new Short("1003") ;
        public static final Short WFS_COMP_APPROVED_OH_DOC = new Short("1004") ;
        public static final Short WFS_COMP_APPROVED_PMB_DOC = new Short("1005") ;
        public static final Short WFS_COMP_APPROVED_OH_HEAD = new Short("1006") ;
        public static final Short WFS_COMP_REJECTED_OH_DOC  = new Short("1007");
        public static final Short WFS_COMP_REJECTED_PMB_DOC  = new Short("1008");
        public static final Short WFS_COMP_REJECTED_OH_HEAD  = new Short("1009");
        public static final Short WFS_COMP_REJECTED_SUPERVISOR = new Short("1010");
        public static final Short WFS_COMP_CANCELLED = new Short("1011") ;
        public static final Short WFS_COMP_APPROVED_HQ_DOC = new Short("1012") ;
        public static final Short WFS_COMP_REJECTED_HQ_DOC = new Short("1013") ;
        public static final Short WFS_COMP_APPROVED_AMB_DOC = new Short("1014") ;
        public static final Short WFS_COMP_REJECTED_AMB_DOC = new Short("1015") ;
        public static final Short WFS_COMP_APPROVED_SA_MED = new Short("1016") ;
        public static final Short WFS_COMP_REJECTED_SA_MED = new Short("1017") ;
        public static final Short WFS_COMP_APPROVED_FO_DIR = new Short("1018") ;
        public static final Short WFS_COMP_REJECTED_FO_DIR = new Short("1019") ;
        public static final Short WFS_COMP_APPROVED_SA_LEG = new Short("1020") ;
        public static final Short WFS_COMP_REJECTED_SA_LEG = new Short("1021") ;
        public static final Short WFS_COMP_APPROVED_DY_GOV = new Short("1022") ;
        public static final Short WFS_COMP_REJECTED_DY_GOV = new Short("1023") ;
        public static final Short WFS_COMP_APPROVED_GOV = new Short("1024") ;
        public static final Short WFS_COMP_REJECTED_GOV = new Short("1025") ;


//T_TRMTSERVICESDET
        /* Addition Begins-MRW-TRMT-SRVC 09/02/2002 for Treatment Services */
        /*TreatmentService status of treatment serivce used in T_TRMTSERVICESDET Table. DB FIELD  - TRMTSRVCSTATUS */
        public static final Short TRMT_SRVC_STS_ENTERED  = new Short("1000");
        public static final Short TRMT_SRVC_STS_APPROVED = new Short("1001");
        public static final Short TRMT_SRVC_STS_REJECTED = new Short("1002");
        public static final Short TRMT_SRVC_STS_CANCELLED = new Short("1003");
        public static final Short TRMT_SRVC_STS_PENDING_WORKFLOW_ENTRY = new Short("1004");
        public static final Short TRMT_SRVC_STS_PENDING_WORKFLOW_ENTRY_RECORRECTED = new Short("1005");



      //T_TRMTSERVICESHDR
        /* Addition Begins-MRW-TRMT-SRVC 09/02/2002 for Treatment Services */
        /*TreatmentService status of treatment serivce used in T_TRMTSERVICESHDR Table. DB FIELD  - APPEALSTATUS */
        public static final Short TRMT_SRVC_HDR_APPEAL_STS_PENDING_DATA_ENTRY  = new Short("1000");
        public static final Short TRMT_SRVC_HDR_APPEAL_STS_ENTERED  = new Short("1001");
        public static final Short TRMT_SRVC_HDR_APPEAL_STS_APPROVED = new Short("1002");
        public static final Short TRMT_SRVC_HDR_APPEAL_STS_REJECTED = new Short("1003");
        public static final Short TRMT_SRVC_HDR_APPEAL_STS_NO_APPEAL = new Short("1004");
        public static final Short TRMT_SRVC_HDR_APPEAL_STS_CANCELLED = new Short("1005");

        public static final Short WFS_SRVC_PENDING_DATA_ENTRY=new Short("1000");
        public static final Short WFS_SRVC_PENDING_WRKFLO_ENTRY=new Short("1001");
        public static final Short WFS_SRVC_ENTERED  =new Short("1002");
        public static final Short WFS_SRVC_VERIFIED =new Short("1003");
        public static final Short WFS_SRVC_APPROVED_SUPERVISOR  =new Short("1004");
        public static final Short WFS_SRVC_REJECTED_SUPERVISOR=new Short("1005");
        public static final Short WFS_SRVC_APPROVED_OH_DOC  =new Short("1006");
        public static final Short WFS_SRVC_REJECTED_OH_DOC  =new Short("1007");
        public static final Short WFS_SRVC_VERIFIED_OH_DOC  =new Short("1008");
        public static final Short WFS_SRVC_APPROVED_OH_HEAD =new Short("1009");
        public static final Short WFS_SRVC_REJECTED_OH_HEAD =new Short("1010");
        public static final Short WFS_SRVC_REJECTED =new Short("1011");
        public static final Short WFS_SRVC_ENTERED_BY_BATCH =new Short("1013");

        /*Treatment Type of treatment service  */
        public static final Short TRMT_SRVC_TYPE_TREATMENT_SERVICE = new Short("1001");
        public static final Short TRMT_SRVC_TYPE_MEDICINE   = new Short("1002");

        /* IOFlag Inpatient 'I' / OutPatient 'O' Flag */
        public static final char TRMT_SRVC_IOFLAG_INPATIENT ='I';
        public static final char TRMT_SRVC_IOFLAG_OUTPATIENT = 'O';

        /*TreatmentService status of Appeal on Deduction treatment serivce used in T_TRMTSERVICESDET Table. DB FIELD  - APPEALDEDCUTIONSTATUS */
        public static final Short TRMT_SRVC_APPEAL_STS_ENTERED  = new Short("1000");
        public static final Short TRMT_SRVC_APPEAL_STS_APPROVED = new Short("1001");
        public static final Short TRMT_SRVC_APPEAL_STS_REJECTED = new Short("1002");
        public static final Short TRMT_SRVC_APPEAL_STS_NO_APPEAL = new Short("1003");
        public static final Short TRMT_SRVC_APPEAL_STS_CANCELLED = new Short("1004");

        /*TreatmentService status of Appeal on Deduction treatment serivce used in T_TRMTSERVICESDET Table. DB FIELD  - APPEALDEDCUTIONWFSTATUS
        public static final Short WFS_SRVC_APPEAL_PENDING_DATA_ENTRY=new Short("1000");
        public static final Short WFS_SRVC_APPEAL_ENTERED   =new Short("1001");
        public static final Short WFS_SRVC_APPEAL_VERIFIED  =new Short("1002");
        public static final Short WFS_SRVC_APPEAL_REJECTED  =new Short("1003");
        public static final Short WFS_SRVC_APPEAL_APPROVED_SUPERVISOR   =new Short("1004");
        public static final Short WFS_SRVC_APPEAL_REJECTED_SUPERVISOR=new Short("1005");
        public static final Short WFS_SRVC_APPEAL_APPROVED_OH_DOC   =new Short("1006");
        public static final Short WFS_SRVC_APPEAL_REJECTED_OH_DOC   =new Short("1007");
        public static final Short WFS_SRVC_APPEAL_VERIFIED_OH_DOC   =new Short("1008");
        public static final Short WFS_SRVC_APPEAL_APPROVED_OH_HEAD  =new Short("1009");
        public static final Short WFS_SRVC_APPEAL_REJECTED_OH_HEAD  =new Short("1010");*/

        //public static final String TRMT_SRVC_STOP_ENTERED_OFFICE_H = "24/10/1434";
        //public static final String TRMT_SRVC_STOP_ENTERED_OFFICE_G = "31/08/2013";


        /*Addition begins for OH Disease JYO*/
        public static final Short WFS_DIS_PENDING_DATA_ENTRY=new Short("1000");
        public static final Short WFS_DIS_ENTERED=new Short("1001");
        public static final Short WFS_DIS_VERIFIED=new Short("1002");
        public static final Short WFS_DIS_APPROVED_SUPERVISOR =new Short("1003");
        public static final Short WFS_DIS_APPROVED_OH_DOC=new Short("1004");
        public static final Short WFS_DIS_APPROVED_PMB_DOC=new Short("1005");
        public static final Short WFS_DIS_APPROVED_OH_HEAD=new Short("1006");
        public static final Short WFS_DIS_APPROVED_FO_DIR=new Short("1007");
        public static final Short WFS_DIS_APPROVED_GVNR=new Short("1008");
        public static final Short WFS_DIS_REJECTED_SUPERVISOR =new Short("1009");
        public static final Short WFS_DIS_REJECTED_OH_DOC=new Short("1010");
        public static final Short WFS_DIS_REJECTED_PMB_DOC=new Short("1011");
        public static final Short WFS_DIS_REJECTED_OH_HEAD=new Short("1012");
        public static final Short WFS_DIS_REJECTED_FO_DIR=new Short("1013");
        public static final Short WFS_DIS_REJECTED_GVNR=new Short("1015");
        public static final Short WFS_DIS_REJECTED=new Short("1014");
        public static final Short WFS_DIS_CANCELLED_SUPERVISOR =new Short("1016");
        public static final Short WFS_DIS_CANCELLED_OH_DOC=new Short("1017");
        public static final Short WFS_DIS_CANCELLED_PMB_DOC=new Short("1018");
        public static final Short WFS_DIS_CANCELLED_OH_HEAD=new Short("1019");
        public static final Short WFS_DIS_CANCELLED_FO_DIR=new Short("1020");
        public static final Short WFS_DIS_CANCELLED_GVNR=new Short("1021");
        public static final Short WFS_DIS_CANCELLED_CLERK=new Short("1022");
        public static final Short WFS_DIS_APPROVED_HO_DOC =new Short("1023");
        public static final Short WFS_DIS_APPROVED_AMB_DOC =new Short("1024");
        public static final Short WFS_DIS_REJECTED_HO_DOC =new Short("1025");
        public static final Short WFS_DIS_REJECTED_AMB_DOC =new Short("1026");
        public static final Short WFS_DIS_CANCELLED_HO_DOC =new Short("1027");
        public static final Short WFS_DIS_CANCELLED_AMB_DOC =new Short("1028");
        public static final Short WFS_DIS_APPROVED_SA_MED =new Short("1029");
        public static final Short WFS_DIS_REJECTED_SA_MED =new Short("1030");
        public static final Short WFS_DIS_CANCELLED_SA_MED =new Short("1031");
        public static final Short WFS_DIS_APPROVED_SA_LEG =new Short("1032");
        public static final Short WFS_DIS_REJECTED_SA_LEG =new Short("1033");
        public static final Short WFS_DIS_CANCELLED_SA_LEG =new Short("1034");
        public static final Short WFS_DIS_APPROVED_DY_GOV =new Short("1035");
        public static final Short WFS_DIS_REJECTED_DY_GOV =new Short("1036");
        public static final Short WFS_DIS_CANCELLED_DY_GOV =new Short("1037");


//T_OHBENEFIT

        /* OH Benefit Code used in T_OHBENEFIT Table. DB FIELD - OHBENCODE.*/
        /** This field denotes OH Allowance for Inpatient Treatment Period*/
        public static final Short OH_ALWNC_DAIlY_INPATIENT=new Short("1001");
        /** This field denotes OH Allowance for Outpatient Treatment Period*/
        public static final Short OH_ALWNC_DAIlY_OUTPATIENT=new Short("1002");
        /** This field denotes OH Allowance for Conveyence */
        public static final Short OH_ALWNC_CONVEYENCE=new Short("1003");
        /** This field denotes OH Allowance for Companion Conveyence*/
        public static final Short OH_ALWNC_COMP_CONVEYENCE=new Short("1005");
        public static final Short OH_ALWNC_AID_APPLIANCE=new Short("1006");
        /** This field denotes OH Allowance for Companion(Others) Daily Allowance*/
        public static final Short OH_ALWNC_COMP_DAILY=new Short("1004");
        /** This field denotes OH Allowance for Companion(Doctor) Daily Allowance*/
        public static final Short OH_ALWNC_DOC_COMP_DAILY=new Short("1008");
        /** This field denotes OH Allowance for Companion(Nurse) Daily Allowance*/
        public static final Short OH_ALWNC_NUR_COMP_DAILY=new Short("1009");
        public static final Short OH_ALWNC_DAILY_INPATIENT_ADJUSTMENT=new Short("1010");
        public static final Short OH_ALWNC_DAILY_OUTPATIENT_ADJUSTMENT=new Short("1011");
        public static final Short OH_ALWNC_CONVEYENCE_ADJUSTMENT=new Short("1012");
        public static final Short OH_ALWNC_MISCELLANEOUS=new Short("1013");

        /* Status for OHBenefit used in T_OHBENEFIT Table. DB FIELD - BENSTATUS.*/
        public static final Short OH_BNFT_STS_ENTERED   = new Short("1001");
        public static final Short OH_BNFT_STS_VERIFIED  = new Short("1002");
        public static final Short OH_BNFT_STS_APPROVED  = new Short("1003");
        public static final Short OH_BNFT_STS_PAID      = new Short("1004");
        public static final Short OH_BNFT_STS_REJECTED  = new Short("1005");
        public static final Short OH_BNFT_STS_RETURNED  = new Short("1006");
        public static final Short OH_BNFT_STS_CANCELLED = new Short("1007");
        public static final Short OH_BNFT_STS_RECOVERED = new Short("1008");
        public static final Short OH_BNFT_STS_RETURNED2 = new Short("1009");

        /* To whom the beneifit is Payable used in T_OHBENEFIT Table. DB FIELD - PAYABLETO. */
        public static final Short OH_BNFT_PAY_TO_EMP = new Short("1");
        public static final Short OH_BNFT_PAY_TO_CON = new Short("2");
        public static final Short OH_BNFT_PAY_TO_HOS = new Short("3");
        public static final Short OH_BNFT_PAY_TO_AUTH_PERSON = new Short("4");

        /* Workflowstatus for OHBenefit used in T_OHBENEIFT Table. DB FIELD - WORKFLOWSTATUS. */
        public static final Short WFS_OH_BNFT_PENDING_DATA_ENTRY =new Short("1000");
        public static final Short WFS_OH_BNFT_ENTERED   =new Short("1001");
        public static final Short WFS_OH_BNFT_VERIFIED  =new Short("1002");
        public static final Short WFS_OH_BNFT_REJECTED_OH_SUPERVISOR=new Short("1003");
        public static final Short WFS_OH_BNFT_APPROVED_OH_HEAD  =new Short("1004");
        public static final Short WFS_OH_BNFT_REJECTED_OH_HEAD  =new Short("1005");
        public static final Short WFS_OH_BNFT_APPROVED_INT_AUD_HEAD =new Short("1006");
        public static final Short WFS_OH_BNFT_REJECTED_INT_AUD_HEAD =new Short("1007");
        public static final Short WFS_OH_BNFT_APPROVED_FO_DIR   =new Short("1008");
        public static final Short WFS_OH_BNFT_REJECTED_FO_DIR   =new Short("1009");
        public static final Short WFS_OH_BNFT_APPROVED_FIN_SEC_MGR  =new Short("1010");
        public static final Short WFS_OH_BNFT_REJECTED_FIN_SEC_MGR  =new Short("1011");
        public static final Short WFS_OH_BNFT_CANCELLED =new Short("1012");
        public static final Short WFS_OH_BNFT_APPROVED_INT_AUD_CLK  =new Short("1013");
        public static final Short WFS_OH_BNFT_REJECTED_INT_AUD_CLK  =new Short("1014");
        public static final Short WFS_OH_BNFT_CHEQUE_CANCELLED  =new Short("1015");
        public static final Short WFS_OH_BNFT_RECOVER = new Short("1016");

//T_VISITS
        /* Visit status in T_VISITS Table. DB Field - VISITSTATUS. */
        public static final Short VISITS_STS_ENTERED   =new Short("1001");
        public static final Short VISITS_STS_APPROVED  =new Short("1002");
        public static final Short VISITS_STS_REJECTED  =new Short("1003");

        /* Workflow status for visits in T_VISITS Table. DB Field - WORKFLOWSTATUS. */
        public static final Short WFS_VISITS_ENTERED    =new Short("1001");
        public static final Short WFS_VISITS_APPROVED_OH_SUPERVISOR=new Short("1002");
        public static final Short WFS_VISITS_REJECTED_OH_SUPERVISOR=new Short("1003");
        public static final Short WFS_VISITS_REJECTED   =new Short("1004");

        /*Added by MRW 11/03/2002 for Treatment Visits */
        /* added by KIRAN for Age Estimation on 02-03-2002 NOT ADDED TO MAIN THING*/
        public static final Short WFS_AGEEST_ENTERED=new Short("1000");
        public static final Short WFS_AGEEST_REENTERED=new Short("1001");
        public static final Short WFS_AGEEST_VERIFIED_PMB_DOC=new Short("1002");
        public static final Short WFS_AGEEST_APPROVED_PMB_HEAD=new Short("1003");
        public static final Short WFS_AGEEST_APPROVED_SOC_AFFAIRS=new Short("1004");
        public static final Short WFS_AGEEST_REJECTED_PMB_DOC=new Short("1005");
        public static final Short WFS_AGEEST_REJECTED_PMB_HEAD=new Short("1006");
        public static final Short WFS_AGEEST_REJECTED_SOC_AFFAIRS=new Short("1007");
        public static final Short WFS_AGEEST_REJECTED=new Short("1008");

        public static final String APPROVE_PMB_HEAD="APPROVE_PMB_HEAD";
        public static final String APPROVE_AMB_HEAD="APPROVE_AMB_HEAD";
        public static final String APPROVE_MB_HEAD="APPROVE_MB_HEAD";
        public static final String APPROVE_PMB_DOCTOR="APPROVE_PMB_DOCTOR";
        public static final String SRCH_MB_OH_DISB_ASSESS="SRCH_MB_OH_DISB_ASSESS";

//T_MBAPPOINTMENT
        /* Type of MedicalBoard in T_MBAPPOINTMENT Table. DB FIELD - MEDICALBOARD*/
        /* Type of MedicalBoard in T_DISBASSMT Table. DB FIELD - MEDICALBOARDNAME*/
        /* Type of MedicalBoard in T_MBDOCTOR Table. DB FIELD - MEDICALBOARD*/
        /* Type of MedicalBoard in T_MBSCHEDULE Table. DB FIELD - MEDICALBOARDNAME*/
        public static final Byte PMB=new Byte("0");
        public static final Byte AMB=new Byte("1");
        public static final Byte LMB=new Byte("2");

        /*These are the assessment status next is not set in db only for checking its used */
        /*Status of appointment used in T_MBAPPOINTMENT Table. DB FIELD - APPOINTMENTSTATUS.*/
        /*Status of assessment used in T_DISBASSMT Table. DB FIELD - ASSESSMENTSTATUS.*/
        public static final Short HEIR_ASSMT_REQ = new Short("1000");   //Only for Heir and non OH
        public static final Short ASSMT_SCHEDULED = new Short("1001");
        public static final Short ASSMT_RESCHEDULED = new Short("1002");
        public static final Short ASSMT_COMPLETED = new Short("1003");
        public static final Short ASSMT_APPEALED = new Short("1004");
        public static final Short ASSMT_APPEAL_WITHDRAWN = new Short("1005");
        public static final Short ASSMT_NEXT = new Short("1006");
        public static final Short ASSMT_CANCELLED = new Short("1007");

//T_DISBASSMT

        /*Disability type used in T_DISBASSMT Table. DB FIELD - DISABILITYTYPE.*/
        /*Assessment type used in T_MBAPPOINTMENT Table. DB FIELD - ASSESSMENTTYPE.*/
        public static final Short OHDISB_ASSMT = new Short("1001");
        public static final Short NONOHDISB_ASSMT = new Short("1002");
        public static final Short HEIRDISB_ASSMT = new Short("1003");
        public static final Short AGEEST_ASSMT = new Short("1004");

        /*Denotes whether the case is stable or not used in T_DISBASSMT Table. DB FIELD - CASENOTSTABLE.*/
        public static final Byte ASSMT_CASE_NOT_STABLE=new Byte("1");
        public static final Byte ASSMT_CASE_STABLE=new Byte("0");

        /*Denotes whether the case is cured with/without disability in T_DISBASSMT Table. DB FIELD - CUREDWITHOUTDISB.*/
        public static final Byte ASSMT_CURE_WITH_DISB=new Byte("0");
        public static final Byte ASSMT_CURE_WITH_OUT_DISB=new Byte("1");

        /*Denotes whether the case in need of companion or not in T_DISBASSMT Table. DB FIELD - NEEDCOMP.*/
        public static final Byte ASSMT_CASE_NEED_COMP=new Byte("1");
        public static final Byte ASSMT_CASE_NEED_NO_COMP=new Byte("0");

        /*Denotes whether the case is OH/NONOH in T_DISBASSMT Table. DB FIELD - CASENOTOCC.*/
        public static final Byte ASSMT_CASE_NOT_OH=new Byte("0");
        public static final Byte ASSMT_CASE_OH=new Byte("1");

        /*Denotes whether the case is disabled or not in T_DISBASSMT Table. DB FIELD - DISBSTATUS.*/
        public static final Byte CASE_IS_DISABLED = new Byte("1");
        public static final Byte CASE_IS_NOT_DISABLED = new Byte("0");
        /*Denotes whether the case is COMPLICATION/NOTCOMPLICATION in T_DISBASSMT Table. DB FIELD - CASENOTCOMPLICATION.*/
        public static final Byte ASSMT_CASE_NOT_COMPLICATION=new Byte("0");
        public static final Byte ASSMT_CASE_COMPLICATION=new Byte("1");

        /*Workflow Status of disabilityassessment used in T_DISBASSMT Table. DB FIELD - WORKFLOWSTATUS.*/
        public static final Short WFS_DISBASSMT_PENDING_DATA_ENTRY=new Short("1000");
        public static final Short WFS_DISBASSMT_ENTERED = new Short("1001");
        public static final Short WFS_DISBASSMT_VERIFIED_PMB_DOC = new Short("1002");
        public static final Short WFS_DISBASSMT_APPROVED_PMB_SECRY = new Short("1003");
        public static final Short WFS_DISBASSMT_APPROVED_SOC_AFFAIRS = new Short("1004");
        public static final Short WFS_DISBASSMT_REJECTED_PMB_DOC = new Short("1005");
        public static final Short WFS_DISBASSMT_REJECTED_PMB_SECRY = new Short("1006");
        public static final Short WFS_DISBASSMT_REJECTED_SOC_AFFAIRS = new Short("1007");
        public static final Short WFS_DISBASSMT_REJECTED = new Short("1008");
        public static final Short WFS_DISBASSMT_APPROVED_HQ_DOC =new Short("1012");
        public static final Short WFS_DISBASSMT_REJECTED_HQ_DOC=new Short("1013");
        public static final Short WFS_DISBASSMT_CANCELLED_HQ_DOC=new Short("1014");
        public static final Short WFS_DISBASSMT_APPROVED_AMB_SECY=new Short("1015");
        public static final Short WFS_DISBASSMT_REJECTED_AMB_SECY=new Short("1016");
        public static final Short WFS_DISBASSMT_CANCELLED_AMB_SECY=new Short("1017");
        public static final Short WFS_DISBASSMT_CANCELLED_SOC_AFFAIRS=new Short("1018");
        //Added for MB Director
        public static final Short WFS_DISBASSMT_APPROVED_MB_DIR = new Short("1019");
        public static final Short WFS_DISBASSMT_REJECTED_MB_DIR = new Short("1020");
        public static final Short WFS_DISBASSMT_CANCELLED_MB_DIR = new Short("1021");
        // Added for appeal
        public static final Short WFS_DISBASSMT_APPEALED_HQ_DOC = new Short("1022");
        public static final Short WFS_DISBASSMT_APPEALED_MB_DIR = new Short("1023");
        public static final Short WFS_DISBASSMT_APPEALED_SOC_AFFAIRS = new Short("1024");
        // new status to be used for finally approved(final approval done other than by soc affairs)
        public static final Short WFS_DISBASSMT_FINALLY_APPROVED = new Short("1004");
        public static final Short WFS_DISBASSMT_BATCH_CANCELLED = new Short("1025");
        // Unsued invalid values for disability Assessment.
        /*Badar not used in system now
        public static final Short WFS_DISBASSMT_APPROVED_SI_DIR=new Short("1022");
        public static final Short WFS_DISBASSMT_REJECTED_SI_DIR=new Short("1023");
        public static final Short WFS_DISBASSMT_CANCELLED_SI_DIR=new Short("1024");
        ---Badar*/
        public static final Short WFS_DISBASSMT_PENDING_DATA_ENTRY_NON_OH=new Short("1000");
        public static final Short WFS_DISBASSMT_ENTERED_NON_OH=new Short("1001");
        public static final Short WFS_DISBASSMT_VERIFIED_PMB_DOC_NON_OH=new Short("1002");
        public static final Short WFS_DISBASSMT_APPROVED_PMB_SECRY_NON_OH =new Short("1003");
        public static final Short WFS_DISBASSMT_APPROVED_SOC_AFFAIRS_NON_OH=new Short("1004");
        public static final Short WFS_DISBASSMT_REJECTED_PMB_DOC_NON_OH=new Short("1005");
        public static final Short WFS_DISBASSMT_REJECTED_PMB_SECRY_NON_OH=new Short("1006");
        public static final Short WFS_DISBASSMT_REJECTED_SOC_AFFAIRS_NON_OH=new Short("1007");
        public static final Short WFS_DISBASSMT_REJECTED_NON_OH=new Short("1008");

//T_MBBENEFIT
        /* Added By MRW for MedicalBoardBenefit on 18/3/2002 6:24 PM */
        /* MedicalBoard Benefit Status in T_MBBENEFIT Table. DB Field - BENEFITSTATUS. */
        public static final Short MB_BNFT_STS_ENTERED  = new Short("1001");
        public static final Short MB_BNFT_STS_APPROVED = new Short("1002");
        public static final Short MB_BNFT_STS_REJECTED = new Short("1003");
        public static final Short MB_BNFT_STS_CANCELLED = new Short("1004");

        /* Workflow status for MedicalBoard Benefit in T_MBBENEFIT Table. DB Field - WORKFLOWSTATUS. */
        public static final Short WFS_MB_BNFT_ENTERED_PMB  =new Short("1001");
        public static final Short WFS_MB_BNFT_ENTERED_AMB  =new Short("1002");
        public static final Short WFS_MB_BNFT_APPROVED_PMB =new Short("1003");
        public static final Short WFS_MB_BNFT_APPROVED_AMB =new Short("1004");
        public static final Short WFS_MB_BNFT_REJECTED_PMB =new Short("1005");
        public static final Short WFS_MB_BNFT_REJECTED_AMB =new Short("1006");
        public static final Short WFS_MB_BNFT_APPROVED_PMB_FIN =new Short("1007");
        public static final Short WFS_MB_BNFT_REJECTED_PMB_FIN =new Short("1008");
        public static final Short WFS_MB_BNFT_APP_PMB_FO_DIR =new Short("1009");
        public static final Short WFS_MB_BNFT_REJ_PMB_FO_DIR =new Short("1010");
        // Added by Suresh
        public static final Short WFS_MB_BNFT_ENTERED  =new Short("1001");
        public static final Short WFS_MB_BNFT_APP_HEAD  =new Short("1002");
        public static final Short WFS_MB_BNFT_REJ_HEAD  =new Short("1003");
        public static final Short WFS_MB_BNFT_APP_INT_AUD_CLK  =new Short("1004");
        public static final Short WFS_MB_BNFT_REJ_INT_AUD_CLK  =new Short("1005");
        public static final Short WFS_MB_BNFT_APP_INT_AUD_MGR  =new Short("1006");
        public static final Short WFS_MB_BNFT_REJ_INT_AUD_MGR  =new Short("1007");
        public static final Short WFS_MB_BNFT_CANCELLED=new Short("1008");

//T_DOCTORATTENDANCE
        /* Status of attandance in T_DOCTORATTENDANCE Table. DB FIELD - STATUS */
        public static final Short DOC_ATTEND_NOTIFIED=new Short("1000");
        public static final Short DOC_ATTEND_APPROVED=new Short("1001");
        public static final Short DOC_ATTEND_REJECTED=new Short("1002");
        public static final Short DOC_ATTEND_CANCELLED=new Short("1003");

//T_DOCTORPAYMENT
        /* Payment status to doctors used in T_DOCTORPAYMENT Table. DB Field - STATUS. */
        public static final Short DOC_PAY_NOTIFIED   =new Short("1000");
        public static final Short DOC_PAY_APPROVED   =new Short("1001");
        public static final Short DOC_PAY_REJECTED   =new Short("1002");
        public static final Short DOC_PAY_CANCELLED   =new Short("1003");

        /*Added By Jyothsna for DoctorPayment on 16-3-2002*/
        public static final Short WFS_DOC_PAY_PENDING_DATA_ENTRY=new Short("1000");
        public static final Short WFS_DOC_PAY_ENTERED=new Short("1001");
        public static final Short WFS_DOC_PAY_APPROVED_PMB_HEAD=new Short("1002");
        public static final Short WFS_DOC_PAY_REJECTED_PMB_HEAD=new Short("1003");
        public static final Short WFS_DOC_PAY_APPROVED_INT_AUD_CLK=new Short("1004");
        public static final Short WFS_DOC_PAY_REJECTED_INT_AUD_CLK=new Short("1005");
        public static final Short WFS_DOC_PAY_APPROVED_INT_AUD_HEAD=new Short("1006");
        public static final Short WFS_DOC_PAY_REJECTED_INT_AUD_HEAD=new Short("1007");
        public static final Short WFS_DOC_PAY_CANCELLED=new Short("1008");
        public static final Short WFS_DOC_PAY_REJECTED=new Short("1009");
        // Added by Kiran for Doctor Payment Interface with Finance
        public static final Short WFS_DOC_PAY_APPROVED_FIN_MGNR=new Short("1005");
        public static final Short WFS_DOC_PAY_REJECTED_FIN_MNGR=new Short("1006");
        public static final Short WFS_DOC_PAY_APPROVED_FO_DIR=new Short("1007");
        public static final Short WFS_DOC_PAY_REJECTED_FO_DIR=new Short("1008");

        /*Added By CQ ID: PRD00023559  for DoctorPayment */
        public static final Short WFS_AMB_DOC_PAY_PENDING_DATA_ENTRY=new Short("1010");
        public static final Short WFS_AMB_DOC_PAY_ENTERED=new Short("1011");
        public static final Short WFS_AMB_DOC_PAY_APPROVED_SA_DIR=new Short("1012");
        public static final Short WFS_AMB_DOC_PAY_REJECTED_SA_DIR=new Short("1013");
        public static final Short WFS_AMB_DOC_PAY_APPROVED_INT_AUD_CLK=new Short("1014");
        public static final Short WFS_AMB_DOC_PAY_REJECTED_INT_AUD_CLK=new Short("1015");
        public static final Short WFS_AMB_DOC_PAY_APPROVED_INT_AUD_HEAD=new Short("1016");
        public static final Short WFS_AMB_DOC_PAY_REJECTED_INT_AUD_HEAD=new Short("1017");
        public static final Short WFS_AMB_DOC_PAY_CANCELLED=new Short("1018");
        public static final Short WFS_AMB_DOC_PAY_REJECTED=new Short("1019");

//T_MBSCHEDULE
        /* Status of the sessions in T_MBSCHEDULE. DB FIELD - SCHEDULESTATUS */
        public static final Byte SCHEDULE_STATUS_CANCELLED=new Byte("0");
        public static final Byte SESSION_SCHEDULED=new Byte("1");

//T_OHDEATHSETTLEMENT
        //Death settlement status used in T_OHDEATHSETTLEMENT Table. DB FIELD - STATUS.
        public static final Short DEATH_SETTLEMENT_STS_ENTERED = new Short("1001");
        public static final Short DEATH_SETTLEMENT_STS_APPROVED = new Short("1002");
        public static final Short DEATH_SETTLEMENT_STS_REJECTED = new Short("1003");
        public static final Short DEATH_SETTLEMENT_STS_CANCELLED = new Short("1004");
        public static final Short DEATH_SETTLEMENT_STS_PAID = new Short("1005");

//T_TOTALDISABILITY
        // Total Disability Benefit status used in T_TOTALDISABILITY Table. DB FIELD - STATUS.
        public static final Short TOTAL_DISB_BENEFIT_ENTERED = new Short("1001");
        public static final Short TOTAL_DISB_BENEFIT_APPROVED = new Short("1002");
        public static final Short TOTAL_DISB_BENEFIT_REJECTED = new Short("1003");
        public static final Short TOTAL_DISB_BENEFIT_CANCELLED = new Short("1004");

        //T_SFDAMAP

        /*Status of map of medicine with SFDA LIST in T_SFDAMAP Table. DB FIELD - STATUS.*/
        public static final Short SFDA_MAP_ENTER=new Short("1001");
        public static final Short SFDA_MAP_MODIFIED=new Short("1002");
        public static final Short SFDA_MAP_CANCELLED=new Short("1003");

        public static final char SFDA_MAP_DRUG_TYPE_MEDICINE='M';
        public static final char SFDA_MAP_DRUG_TYPE_HERBAL='H';
        public static final char SFDA_MAP_DRUG_TYPE_UN_REGISTERED='U';



        //T_RECFROMEMP

        /*Status of amount recover from employer used in T_RECFROMEMP Table. DB FIELD - STATUS.*/
        public static final Short REC_FROM_EMP_ENTERED=new Short("1001");
        public static final Short REC_FROM_EMP_APPROVED=new Short("1002");
        public static final Short REC_FROM_EMP_REJECTED=new Short("1003");
        public static final Short REC_FROM_EMP_CANCELLED=new Short("1004");
        public static final Short REC_FROM_EMP_AMOUNT_RETURNED=new Short("1005");

        /*RecoveryType used in T_RECFROMEMP Table. DB FIELD - RECOVERYTYPE.*/
        public static final Short RECOVERY_TYPE_OH_BENEFIT = new Short("1001");
        public static final Short RECOVERY_TYPE_REG_HOSP_INVOICE = new Short("1002");
        public static final Short RECOVERY_TYPE_UNREG_HOSP_INVOICE = new Short("1003");

        /*Workflow status of amount recover from employer used in T_RECFROMEMP Table. DB FIELD - WORKFLOWSTATUS.*/
        public static final Short REC_FROM_EMP_CLERK_ENT=new Short("1001");
        public static final Short REC_FROM_EMP_APP_SUPERVISOR=new Short("1002");
        public static final Short REC_FROM_EMP_REJ_SUPERVISOR=new Short("1003");
        public static final Short REC_FROM_EMP_APP_OHHEAD=new Short("1004");
        public static final Short REC_FROM_EMP_REJ_OHHEAD=new Short("1005");
        public static final Short REC_FROM_EMP_APP_CLERK_REENT=new Short("1006");
        public static final Short REC_FROM_EMP_REJ_CLERK_REENT=new Short("1007");
        public static final Short REC_FROM_EMP_APP_FO_DIR=new Short("1008");
        public static final Short REC_FROM_EMP_REJ_FO_DIR=new Short("1009");
        public static final Short REC_FROM_EMP_APP_DY_GOV=new Short("1010");
        public static final Short REC_FROM_EMP_REJ_DY_GOV=new Short("1011");
        public static final Short REC_FROM_EMP_APP_FIN_SEC_MNGR=new Short("1012");
        public static final Short REC_FROM_EMP_REJ_FIN_SEC_MNGR=new Short("1013");
        public static final Short REC_FROM_EMP_APP_INT_AUD_CLK=new Short("1014");
        public static final Short REC_FROM_EMP_REJ_INT_AUD_CLK=new Short("1015");
        public static final Short REC_FROM_EMP_APP_INT_AUD_MGR=new Short("1016");
        public static final Short REC_FROM_EMP_REJ_INT_AUD_MGR=new Short("1017");
        public static final Short WFS_REC_FROM_EMP_CANCELLED=new Short("1018");

        public static final Short MEDICAL_REPORT_REQUIRED = new Short("1001");
        public static final Short MEDICAL_REPORT_NOT_REQUIRED = new Short("1002");

//T_MBDOCTOR
        /* Type of the Doctor in T_MBDOCTOR Table. DB FIELD - DOCTORTYPE */
        public static final Short TYPE_DOCTOR = new Short("1001");
        public static final Short TYPE_NURSE = new Short("1002");

        /* Status of Doctor in T_MBDOCTOR Table. DB FIELD - STATUS */
        public static final Byte DOCT_STATUS_ACTIVE=new Byte("0");
        public static final Byte DOCT_STATUS_INACTIVE=new Byte("1");

//T_HOSPITAL
        /*Type of Hospital used in T_HOSPITAL Table. DB FIELD - HOSPITALTYPE.*/
        public static final Short REG_HOSPITAL = new Short("1001");
        public static final Short UNREG_HOSPITAL = new Short("1002");
        public static final Short GOVT_FREE_HOSPITAL = new Short("1003");
        public static final Short GOVT_PAID_HOSPITAL = new Short("1004");
        public static final Short CANCELLED_HOSPITAL = new Short("1005");
//T_UNREGHOSPINVOICEHDR
        /*Stauts of the unregistered hospital invoice used in T_UNREGHOSPINVOICEHDR Table. DB FIELD - INVOICESTATUS.*/
        public static final Short UN_REG_HOSP_INVC_ENTERED  =new Short("1000");
        public static final Short UN_REG_HOSP_INVC_APPROVED =new Short("1001");
        public static final Short UN_REG_HOSP_INVC_REJECTED =new Short("1002");
        public static final Short UN_REG_HOSP_INVC_PAID     =new Short("1003");
        public static final Short UN_REG_HOSP_INVC_CANCELLED=new Short("1004");

        /*Workflow Stauts of the unregistered hospital invoice used in T_UNREGHOSPINVOICEHDR Table. DB FIELD - WORKFLOWSTATUS.*/
        public static final Short WFS_URH_INVC_ENTERED  =new Short("1000");
        public static final Short WFS_URH_INVC_REJECTED =new Short("1001");
        public static final Short WFS_URH_INVC_VERIFIED =new Short("1002");
        public static final Short WFS_URH_INVC_REJECTED_OH_SUPERVISOR =new Short("1003");
        public static final Short WFS_URH_INVC_APPROVED_OH_DOC =new Short("1004");
        public static final Short WFS_URH_INVC_REJECTED_OH_DOC =new Short("1005");
        public static final Short WFS_URH_INVC_APPROVED_OH_HEAD=new Short("1006");
        public static final Short WFS_URH_INVC_REJECTED_OH_HEAD=new Short("1007");
        public static final Short WFS_URH_INVC_APPROVED_FO_DIR=new Short("1008");
        public static final Short WFS_URH_INVC_REJECTED_FO_DIR=new Short("1009");
        public static final Short WFS_URH_INVC_APPROVED_PMB_DOC=new Short("1010");
        public static final Short WFS_URH_INVC_REJECTED_PMB_DOC=new Short("1011");
        public static final Short WFS_URH_INVC_APPROVED_HQ_DOC=new Short("1012");
        public static final Short WFS_URH_INVC_REJECTED_HQ_DOC=new Short("1013");
        public static final Short WFS_URH_INVC_APPROVED_AMB_DOC=new Short("1014");
        public static final Short WFS_URH_INVC_REJECTED_AMB_DOC=new Short("1015");
        public static final Short WFS_URH_INVC_APPROVED_SA_MED=new Short("1016");
        public static final Short WFS_URH_INVC_REJECTED_SA_MED=new Short("1017");
        public static final Short WFS_URH_INVC_APPROVED_SA_LEG=new Short("1018");
        public static final Short WFS_URH_INVC_REJECTED_SA_LEG=new Short("1019");
        public static final Short WFS_URH_INVC_APPROVED_DY_GOV=new Short("1020");
        public static final Short WFS_URH_INVC_REJECTED_DY_GOV=new Short("1021");
        public static final Short WFS_URH_INVC_APPROVED_GOV=new Short("1022");
        public static final Short WFS_URH_INVC_REJECTED_GOV=new Short("1023");
        public static final Short WFS_URH_INVC_APPROVED_INT_AUD_CLK=new Short("1024");
        public static final Short WFS_URH_INVC_REJECTED_INT_AUD_CLK=new Short("1025");
        public static final Short WFS_URH_INVC_APPROVED_INT_AUD_MGR=new Short("1026");
        public static final Short WFS_URH_INVC_REJECTED_INT_AUD_MGR=new Short("1027");
        public static final Short WFS_URH_INVC_CANCELLED = new Short("1028");
        public static final Short WFS_URH_INVC_SAVE_AS_REJECTED = new Short("1029");
        public static final Short WFS_URH_INVC_CANCELLED_OH_SUPERVISOR = new Short("1030");
        public static final Short WFS_URH_INVC_CANCELLED_OH_DOC = new Short("1031");
        public static final Short WFS_URH_INVC_CANCELLED_OH_HEAD = new Short("1032");
        public static final Short WFS_URH_INVC_CANCELLED_FO_DIR = new Short("1033");
        public static final Short WFS_URH_INVC_CANCELLED_FIN_SEC_MGR = new Short("1034");

        //radio button ProvideBy
        public static final Short URH_INVC_PROVIDE_INSIDE_HOSPTAIL = new Short("1");
        public static final Short URH_INVC_PROVIDE_OUTSIDE_HOSPTAIL = new Short("2");


//T_OHAUTHORIZEDPERSON
        /*active stauts of the OH authorized person for a contributor used in T_OHAUTHORIZEDPERSON Table. DB FIELD - STATUS.*/
        public static final Short AUTHORIZED_PERSON_STATUS_ACTIVE=new Short("0");
        public static final Short AUTHORIZED_PERSON_STATUS_INACTIVE=new Short("1");

//T_REGHOSPINVOICEHDR
        /* Status of Registered Hospital Invoice used in T_REGHOSPINVOICEHDR. DB FIELD - INVOICESTATUS */
        public static final Short REG_HOSP_INVC_PENDING_DATA_ENTRY =new Short("1000");
        public static final Short REG_HOSP_INVC_ENTERED  =new Short("1001");
        public static final Short REG_HOSP_INVC_APPROVED =new Short("1002");
        public static final Short REG_HOSP_INVC_REJECTED =new Short("1003");
        public static final Short REG_HOSP_INVC_CANCELLED=new Short("1004");
        public static final Short REG_HOSP_INVC_PAID     =new Short("1005");
        public static final Short REG_HOSP_INVC_PENDING_APPROVED  =new Short("1006");

        /* Status of Registered Hospital Invoice used in T_REGHOSPINVOICEHDR. DB FIELD - BATCHPROCESSED */
        public static final Byte REG_HOSP_INVC_BATCH_PROCESSED_FALSE =new Byte("0");
        public static final Byte REG_HOSP_INVC_BATCH_PROCESSED_TRUE =new Byte("1");


        /* Status of Registered Hospital Invoice used in T_TRMTSERVICESDET. DB FIELD - ISNPERIODDEDUCTED */
        public static final Byte TRMT_SRVC_NO_PERIOD_DEDUCTED =new Byte("0");
        public static final Byte TRMT_SRVC_PERIOD_DEDUCTED =new Byte("1");



//T_REGHOSPINVOICEDET
        /* Status of Registered Hospital Invoice used in T_REGHOSPINVOICEDET. DB FIELD - STATUS */
        public static final Short REG_HOSP_INVC_DETAILS_ENTERED  =new Short("1001");
        public static final Short REG_HOSP_INVC_DETAILS_IN_WORKFLOW =new Short("1002");
        public static final Short REG_HOSP_INVC_DETAILS_APPROVED =new Short("1003");
        // REG_HOSP_INVC_DETAILS_REJECTED status is no longer use
        public static final Short REG_HOSP_INVC_DETAILS_REJECTED =new Short("1004");
        public static final Short REG_HOSP_INVC_DETAILS_CANCELLED=new Short("1005");

        /* Status of Registered Hospital Invoice used in T_REGHOSPINVOICEDET. DB FIELD - BATCHPROCESSED */
        public static final Byte REG_HOSP_INVC_DET_BATCH_PROCESSED_FALSE =new Byte("0");
        public static final Byte REG_HOSP_INVC_DET_BATCH_PROCESSED_TRUE =new Byte("1");

//T_TRANSFEROH
        /* Status for transferOH used in T_TRANSFEROH Table. DB FIELD - STATUS. */
        public static final Short TRANSFER_STS_NOTIFIED = new Short("1000");
        public static final Short TRANSFER_STS_APPROVED = new Short("1001");
        public static final Short TRANSFER_STS_REJECTED = new Short("1002");
        public static final Short TRANSFER_STS_CANCELLED=new Short("1003");

        /* Workflowstatus for transferOH used in T_TRANSFEROH Table. DB FIELD - WORKFLOWSTATUS. */
        public static final Short WFS_TRANS_OH_PENDING_DATA_ENTRY=new Short("1000");
        public static final Short WFS_TRANS_OH_ENTERED=new Short("1001");
        public static final Short WFS_TRANS_OH_VERIFIED=new Short("1002");
        public static final Short WFS_TRANS_OH_APPROVED_HEAD =new Short("1003");
        public static final Short WFS_TRANS_OH_REJECTED_SUPERVISOR =new Short("1004");
        public static final Short WFS_TRANS_OH_REJECTED_HEAD =new Short("1005");
        public static final Short WFS_TRANS_OH_REJECTED=new Short("1006");

        /* Workflowstatus for transferOH used in T_TRANSFEROH Table. DB FIELD - TRANSPORTATIONREQUIRED. */
        public static final Byte TRANSPORTATION_IS_REQUIRED = new Byte("1");
        public static final Byte TRANSPORTATION_IS_NOT_REQUIRED = new Byte("0");

//T_HOSPITALDISCOUNT
        /* Type of Discount by hospitals in T_HOSPITALDISCOUNT Table. DB FIELD - DISCOUNTTYPE.*/
        public static final Byte DISC_MEDICINES=new Byte("1");
        public static final Byte DISC_SERVICES=new Byte("2");
        public static final Byte DISC_TOT_AMOUNT=new Byte("3");
//T_RECFROMCONTRIBUTOR
        /* Workflowstatus in T_RECFROMCONTRIBUTOR Table. DB Field - WORKFLOWSTATUS. */
        public static final Short REC_FROM_CON_CLERK_ENT=new Short("1001");
        public static final Short REC_FROM_CON_APP_SUPERVISOR=new Short("1002");
        public static final Short REC_FROM_CON_REJ_SUPERVISOR=new Short("1003");
        public static final Short REC_FROM_CON_APP_OHHEAD=new Short("1004");
        public static final Short REC_FROM_CON_REJ_OHHEAD=new Short("1005");
        public static final Short REC_FROM_CON_APP_CLERK_REENT=new Short("1006");
        public static final Short REC_FROM_CON_REJ_CLERK_REENT=new Short("1007");
        public static final Short REC_FROM_CON_APP_FIN_SEC_MNGR=new Short("1008");
        public static final Short REC_FROM_CON_REJ_FIN_SEC_MNGR=new Short("1009");
        public static final Short REC_FROM_CON_APP_FO_DIR=new Short("1010");
        public static final Short REC_FROM_CON_REJ_FO_DIR=new Short("1011");
        //public static final Short REC_FROM_CON_CANCELLED=new Short("1012");
        public static final Short REC_FROM_CON_APP_INT_AUD_CLK=new Short("1013");
        public static final Short REC_FROM_CON_REJ_INT_AUD_CLK=new Short("1014");
        public static final Short REC_FROM_CON_APP_INT_AUD_MGR=new Short("1015");
        public static final Short REC_FROM_CON_REJ_INT_AUD_MGR=new Short("1016");
        public static final Short WFS_REC_FROM_CON_CANCELLED=new Short("1017");

        public static final Short REC_FROM_CON_ENTERED=new Short("1001");
        public static final Short REC_FROM_CON_APPROVED=new Short("1002");
        public static final Short REC_FROM_CON_REJECTED=new Short("1003");

//T_OHESTCHANGES
        /* this added BY Yazeed for Table T_OHESTCHANGES - status */
        public static final Short REG_NUMBER_CHANGE_ENTERED = new Short("1001");
        public static final Short REG_NUMBER_CHANGE_REJECTED = new Short("1002");
        public static final Short REG_NUMBER_CHANGE_CANCELLED = new Short("1003");
        public static final Short REG_NUMBER_CHANGE_APPROVED = new Short("1004");

//T_OHESTCHANGES

        /* this added BY Yazeed for Table T_OHESTCHANGES - Workflowstatus */
        public static final Short WFS_REG_NUMBER_CHANGE_ENTERED_BY_SUPERVISOR = new Short("1010");
        public static final Short WFS_REG_NUMBER_CHANGE_REJECTED_BY_SUPERVISOR = new Short("1011");
        public static final Short WFS_REG_NUMBER_CHANGE_RENTERED_BY_SUPERVISOR = new Short("1012");
        public static final Short WFS_REG_NUMBER_CHANGE_CANCELLED_BY_OH_SUPERVISOR = new Short("1013");
        public static final Short WFS_REG_NUMBER_CHANGE_REJECTED_BY_OH_HEAD = new Short("1014");
        public static final Short WFS_REG_NUMBER_CHANGE_APPROVED_BY_OH_HEAD = new Short("1015");
//T_MR

        /* this added BY abdulrazaq for Table T_MR - MRTYPE */
        public static final Short MEDICAL_REPORT_TYPE_FOR_EXTENSTION = new Short("1000");
        public static final Short MEDICAL_REPORT_TYPE_FOR_TRMT_WITH_CLOSE = new Short("1001");
        public static final Short MEDICAL_REPORT_TYPE_FOR_TRMT = new Short("1002");
        public static final Short MEDICAL_REPORT_TYPE_FOR_REQ_APPROVAL = new Short("1003");
        public static final Short MEDICAL_REPORT_TYPE_FOR_OH_SICKLEAVE = new Short("1004");

    /* JNDI Names of EJBS in OH Module */

    public static final String AID_APPLIANCE_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.AidApplianceEntityJNDI";

    public static final String OH_ALLOWANCE_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.OHAllowanceEntityJNDI";

    public static final String COMPANION_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.CompanionEntityJNDI";

    public static final String TRMT_EXTN_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.TreatmentExtensionEntityJNDI";

    public static final String DEATH_DISABLITY_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.DeathDisabilityEntityJNDI";

    public static final String TRMT_PRD_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.TreatmentEntityJNDI";

    public static final String TRMT_VISITS_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.VisitsEntityJNDI";

    public static final String TRMT_SRVC_HDR_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.TreatmentServiceHeaderEntityJNDI";

    public static final String TRMT_SRVC_DET_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.TreatmentServiceDetailEntityJNDI";

    public static final String TRTM_SRVC_LIST_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.TrtmServiceListEntityJNDI";

    public static final String TRTM_SRVC_LIST_HISTORY_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.TrtmServiceListHistoryEntityJNDI";

    public static final String MB_BENEFIT_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.MBBenefitEntityJNDI";

    public static final String TOTAL_DISABILITY_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.TotalDisabilityEntityJNDI";

    public static final String PAYMENT_BANK_ENTITY_JNDI =
    "gosi.database.socialinsurance.annuities.entity.PaymentBankAccountEntityJNDI";

    public static final String MTN_TRMT_PRD_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainTreatmentPeriodSessionJNDI";

    public static final String MTN_TRMT_SRVC_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainTreatmentServiceSessionJNDI";

    public static final String MTN_TRMT_EXTN_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainTreatmentExtensionSessionJNDI";

    public static final String TREATMENT_SERVICE_REQUEST_APPROVAL_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.TreatmentServiceReqApprovalEntityJNDI";

    public static final String MTN_COMPANION_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainCompanionSessionJNDI";

    public static final String MTN_OH_ALLOWANCE_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainOHAllowanceSessionJNDI";

    public static final String MTN_DISB_TRMT_SRVC_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainDisabilityTreatmentSessionJNDI";

    public static final String MTN_UNREG_HOSP_INVOICE_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainUnRegHospitalInvoiceSessionJNDI";

    public static final String MTN_MB_BENEFIT_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainMBBenefitSessionJNDI";

    public static final String MAINTAIN_INJURY_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainInjurySessionJNDI";

    public static final String MAINTAIN_INJURY_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.InjuryEntityJNDI";

    public static final String MAINTAIN_DOCTOR_PAYMENT_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainDoctorPaymentSessionJNDI";

    public static final String MAINTAIN_DISEASE_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainDiseaseSessionJNDI";

    public static final String MAINTAIN_CASE_INCHARGE_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainCaseInchargeSessionJNDI";

    public static final String MAINTAIN_OH_INSPECTION_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainOHInspectionSessionJNDI";

    public static final String MAINTAIN_OH_LIST_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainOHListSessionJNDI";

    public static final String MAINTAIN_PMR_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainPMRSessionJNDI";

    public static final String MAINTAIN_TRANSFER_OH_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainTransferOHSessionJNDI";

    public static final String MAINTAIN_TRANSFER_TO_DISEASE_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainTransferToDiseaseSessionJNDI";

    public static final String SEARCH_CASE_INCHARGE_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.SearchCaseInchargeSessionJNDI";

    public static final String SEARCH_INJURY_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.SearchInjurySessionJNDI";

    public static final String SEARCH_OH_DMS_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.SearchDMSSessionJNDI";

    public static final String INJURY_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.InjuryEntityJNDI";

    public static final String TRANSFER_OH_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.TransferOHEntityJNDI";

    public static final String BODY_PARTS_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.BodyPartsEntityJNDI";

    public static final String INJURY_DOC_REQ_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.InjuryDocReqEntityJNDI";

    public static final String PREEXIST_DEFORMITIES_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.PreexistingDeformitiesEntityJNDI";

    public static final String CONTRIBUTOR_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.ContributorEntityJNDI";

    public static final String DOCTOR_PAYMENT_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.DoctorPaymentEntityJNDI";

    public static final String DOCTOR_PAYMENT_ATTENDANCE_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.DoctorPaymentAttendanceEntityJNDI";

    public static final String PMR_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.PMREntityJNDI";

    public static final String CASE_INCHARGE_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.CaseInchargeEntityJNDI";

    public static final String MAINTAIN_DOCTOR_SESSION_JNDI=
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainDoctorSessionJNDI";

    public static final String INJURY_DIAGNOSIS_ENTITY_JNDI=
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.InjuryDiagnosisEntityJNDI";

    public static final String REG_HOSP_INVOICE_HEADER_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.RegHospitalInvoiceHeaderEntityJNDI";

    public static final String REG_HOSP_INVOICE_DETAILS_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.RegHospitalInvoiceDetailEntityJNDI";

    public static final String MTN_REG_HOSP_INVOICE_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainRegHospitalInvoiceSessionJNDI";

    public static final String MAINTAINMOVEHOSPTOFOSESSIONJNDI=
    "gosi.business.socialinsurance.occupationalhazards.hospital.session.MaintainHospitalMoveToFOSessionJNDI";

    public static final String MAINTAINHOSPITALENTITYJNDI=
    "gosi.database.socialinsurance.occupationalhazards.hospital.entity.HospitalEntityJNDI";

    public static final String MAINTAINMOVEHOSPTOFOENTITYJNDI=
    "gosi.database.socialinsurance.occupationalhazards.hospital.entity.MaintainMoveHospitalFOEntityJNDI";

    public static final String MTN_TRMT_SRV_QUERY_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainTreatmentServiceQuerySessionJNDI";

    public static final String MTN_HOSP_TRMT_SRV_QUERY_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.hospital.session.MaintainHospitalTreatmentServiceQuerySessionJNDI";

    public static final String MAINTAIN_STOP_RESUME_ALLOWANCE_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainStopOrResumeAllowanceSessionJNDI";

    public static final String MAINTAIN_OH_SERVICES_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.common.session.MaintainOHServicesSessionJNDI";

    public static final String STOP_RESUME_ALLOWANCE_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.StopOrResumeAllowanceEntityJNDI";

    public static final String MAINTAIN_INJURY_SOURCE_MASTER_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainInjurySourceMasterSessionJNDI";

    public static final String INJURY_SOURCE_MASTER_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.MaintainInjurySourceMasterEntityJNDI";

    public static final String REJ_OH_INJ_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainRejectOHInjurySessionJNDI";

    public static final String MAINTAIN_INJURY_NATURE_MASTER_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainInjuryNatureMasterSessionJNDI";

    public static final String INJURY_NATURE_MASTER_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.MaintainInjuryNatureMasterEntityJNDI";

    public static final String MAINTAIN_ACCIDENT_TYPE_MASTER_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainAccidentTypeMasterSessionJNDI";

    public static final String MAINTAIN_NOTIFY_INJURY_INTERNET_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainNotifyInjuryInternetSessionJNDI";

    public static final String NOTIFY_INJURY_INTERNET_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.MaintainNotifyInjuryInternetEntityJNDI";

    public static final String ACCIDENT_TYPE_MASTER_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.MaintainAccidentTypeMasterEntityJNDI";

    public static final String MAINTAIN_HOSPITAL_CONTRACT_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.hospital.session.MaintainHospitalContractSessionJNDI";

    public static final String MAINTAIN_TREATMENT_INVOICE_QUERY_SESSION_JNDI=
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainTreatmentInvoiceQuerySessionJNDI";

    public static final String CREATE_MB_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainCreateMedicalBoardSessionJNDI";

    public static final String MODIFY_MB_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainModifyMedicalBoardSessionJNDI";

    public static final String CANCEL_MB_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainCancelMedicalBoardSessionJNDI";

    public static final String ASSIGN_MB_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainAssignMedicalBoardSessionJNDI";

    public static final String SEARCH_MB_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.SearchSessionsSessionJNDI";

    public static final String OH_DISB_ASSMT_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainOHDisabilityAssessmentSessionJNDI";

    public static final String NON_OH_DISB_ASSMT_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainNonOHDisabilityAssessmentSessionJNDI";

    public static final String HEIR_DISB_ASSMT_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainHeirDisabilityAssessmentSessionJNDI";

    public static final String AGE_EST_ASSMT_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainAgeEstimationSessionJNDI";

    public static final String REC_FROM_EMP_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainRecoveryFromEmployerSessionJNDI";

    public static final String REC_FROM_CON_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.medicalboard.session.MaintainRecoverFromContributorSessionJNDI";


    public static final String HOSPITAL_CONTRACT_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.hospital.entity.HospitalContractEntityJNDI";

    public static final String HOSPITAL_DISCOUNT_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.hospital.entity.HospitalDiscountEntityJNDI";

    public static final String HOSPITAL_DEPARTMENT_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.hospital.entity.HospitalDepartmentEntityJNDI";

    public static final String HOSPITAL_TREATMENT_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.hospital.entity.HospitalTreatmentEntityJNDI";

    public static final String HOSPITAL_EVALUATION_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.hospital.entity.HospitalEvaluationEntityJNDI";

    public static final String HOSPITAL_FO_ASSOCIATION_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.hospital.entity.HospitalFOAssociationEntityJNDI";

    public static final String UNREG_HOSP_INVOICE_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.UnRegHospitalInvoiceEntityJNDI";

    public static final String UNREG_HOSP_SERVICE_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.UnRegHospitalServicesEntityJNDI";

    public static final String REC_FROM_EMP_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.RecEmployerEntityJNDI";

    public static final String REC_FROM_CON_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.RecFromContributorEntityJNDI";

    public static final String OH_AUTHORIZED_PERSON_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.OHAuthorizedPersonEntityJNDI";

    public static final String CREATE_MB_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.CreateMedicalBoardEntityJNDI";

    public static final String CANCEL_MB_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.CancelMedicalBoardEntityJNDI";

    public static final String ASSGN_MB_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.AssignMedicalBoardEntityJNDI";

    public static final String DISB_ASSMT_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.OHDisabilityAssessmentEntityJNDI";

    public static final String AGE_EST_ASSMT_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.AgeEstimationEntityJNDI";

    public static final String DOC_FO_ASSOCIATION_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.medicalboard.entity.DoctorFOAssociationEntityJNDI";

    public static final String MAINTAIN_OH_SERVICES_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.common.entity.MaintainOHServicesEntityJNDI";

    public static final String REJ_OH_INJ_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.RejectOHInjuryEntityJNDI";

    public static final String OH_AUTHORIZED_PERSON_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainAuthorizedPersonSessionJNDI";

    public static final String RESUMETREATMET_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.ResumeTreatmentEntityJNDI";

    public static final String OHESTCHANGES_ENTITY_JNDI =
        "gosi.database.socialinsurance.occupationalhazards.injury.entity.OHestChangesEntityJNDI";

    public static final String MR_ENTITY_JNDI =
    "gosi.database.socialinsurance.occupationalhazards.injury.entity.MREntityJNDI";

    public static final String MAINTAIN_MR_SESSION_JNDI =
    "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainMRSessionJNDI";

    public static final String SFDA_MAP_ENTITY_JNDI =
        "gosi.database.socialinsurance.occupationalhazards.injury.entity.SFDAMapEntityJNDI";

    public static final String MAINTAIN_OH_SICKLEAVE_SESSION_JNDI =
        "gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainOHSickleaveSessionJNDI";

    public static final String SICKLEAVE_ENTITY_JNDI =
        "gosi.database.socialinsurance.occupationalhazards.injury.entity.SickleaveEntityJNDI";

        //Type of services provided by OH Department.
        //Service type Treatment for any OH Injury
        public static final String SERVICE_TYPE_TRMT = "1";
        //Service type Disability Treatment for any Disability from Medical Board.
        public static final String SERVICE_TYPE_DISB_TRMT = "2";
        public static final String SERVICE_TYPE_MISC = "3";
        //Service type Complication Treatment for any complication happend after Injury.
        public static final String SERVICE_TYPE_COMPLICATION_TRMT = "4";


        public static final Short RANGE_TYPE_VALUE=new Short("1");
        public static final Short RANGE_TYPE_DAYS=new Short("2");
        /*********Changed for second version********************/
        public static final Long NO_OF_DAYS_NINETY=new Long("90");
        public static final Long NO_OF_DAYS_ZERO=new Long("0");
        public static final Long NO_OF_DAYS_ONEEIGHTY=new Long("180");
        public static final Long NO_OF_DAYS_ONE_YEAR=new Long("365");
        public static final Long NO_OF_DAYS_NINETEENHUNDRED=new Long("1900");
        /*******Change ends here*********************************/
        /* public static final Integer NO_OF_DAYS_NINETY_ONE=new Integer("90");
        public static final Integer NO_OF_DAYS_ZERO=new Integer("0");
        public static final Integer NO_OF_DAYS_ONEEIGHTY=new Integer("180");
        public static final Integer NO_OF_DAYS_NINETEENHUNDRED=new Integer("1900");
       */
        public static final Long RANGE_VALUE_PMB=new Long("1");
        public static final Long RANGE_VALUE_HEAD=new Long("0");

        public static final Byte NEW_INJURY = new Byte("1");
        public static final Byte NEW_OCC_DISEASE = new Byte("2");
        public static final Byte COMPLICATION_INJURY = new Byte("3");
        public static final Byte COMPLICATION_OCC_DISEASE = new Byte("4");

        public static final Long RANGE_VALUE_CONTINUE=new Long("1");
        public static final Long RANGE_VALUE_STOP = new Long("0");
        public static final Long RANGE_VALUE_CONTINUE_2 = new Long("2");
        /* Addition Begins - JYO - 07/02/2002 for Companion */
        /*
         * Verification Status Combo to be populated
         */
        public static final Short LEGAL = new Short("1");
        public static final Short MEDICAL = new Short("2");
        public static final Short OFFICE = new Short("1");
        public static final Short HOSPITAL = new Short("2");
        public static final Short WAIVE_FLAG_TRUE = new Short("2");
        public static final Short WAIVE_FLAG_FALSE = new Short("1");
        public static final Short EXCEEDS_YEAR_FLAG_TRUE = new Short("2");
        public static final Short EXCEEDS_YEAR_FLAG_FALSE = new Short("1");
        public static final Short SAVE_REJECTED = new Short("3");
        public static final Short FINAL_APPROVE = new Short("4");
        public static final Short FURTHER_APPROVAL = new Short("1");
        public static final Short FURTHER_APPROVAL_FROM_FIN = new Short("5");


        public static final Short FINAL_APPROVE_OH = new Short("4");
        public static final Short FINAL_APPROVE_FIN = new Short("5");

        public static final String APPROVE_OHDOC ="APPROVE_OHDOC";
        public static final String APPROVE_PMB   ="APPROVE_PMB";
        public static final String APPROVE_HQDOC ="APPROVE_HQ_DOC";
        public static final String APPROVE_AMB   ="APPROVE_AMB";
        public static final String APPROVE_SA_MED="APPROVE_SA_MED";

        public static final String APPROVE_OHHEAD="APPROVE_OHHEAD";
        public static final String APPROVE_FOHEAD="APPROVE_FOHEAD";
        public static final String APPROVE_SA_LEG="APPROVE_SA_LEG";
        public static final String APPROVE_DY_GOV="APPROVE_DY_GOV";
        public static final String APPROVE_GOV   ="APPROVE_GOV";
        public static final String APPROVE_AMB_DOC ="APPROVE_AMB_DOC";
        public static final String APPROVE_PMB_DOC ="APPROVE_PMB_DOC";

        public static final String APPROVE_SADIR_MED="APPROVE_SADIR_MED";
        public static final String APPROVE_SADIR_LEG="APPROVE_SADIR_LEG";
        public static final String APPROVE_DEP_GOV="APPROVE_DEP_GOV";
        public static final String APPROVE_HQ_DOC="APPROVE_HQ_DOC";
        public static final String APPROVE_INT_AUD_CLK="APPROVE_INT_AUD_CLK";

        //ADDED BY - CQ ID : PRD00024062
        public static final String APPR_HQ_INT_AUD_CLK="APPROVE_HQ_INT_AUD_CLK";
        public static final String APPR_HQ_INT_AUD_HEAD="APPROVE_HQ_INT_AUD_HEAD";

        public static final Short VERIFY_SUPERVISOR=new Short("2001");
        public static final Short APPROVE_DOCTOR=new Short("2002");
        public static final Short APPROVE_PMB_SEC=new Short("2003");
        public static final Short APPROVE_HQ_DOCTOR=new Short("2004");
        public static final Short APPROVE_AMB_SEC=new Short("2005");
        public static final Short APPROVE_SA_DIRECTOR=new Short("2006");

        public static final Short APPROVE_SA_DIRECTOR_LEG=new Short("1011");
        public static final Short APPROVE_DY_GOVERNOR=new Short("1011");
        public static final Short APPROVE_GOVERNOR=new Short("1011");

        public static final Short FROM_SUPERVISOR=new Short("1");
        public static final Short FROM_DOCTOR=new Short("2");
        public static final Short FROM_PMB_SEC=new Short("3");
        public static final Short FROM_HQ_DOCTOR=new Short("4");
        public static final Short FROM_AMB_SEC=new Short("5");
        public static final Short FROM_SA_DIRECTOR=new Short("6");
        public static final Short FROM_OH_HEAD=new Short("2");
        public static final Short FROM_FO_DIR=new Short("3");
        public static final Short FROM_SA_DIR_LEG=new Short("4");
        public static final Short FROM_DY_GOV=new Short("5");
        public static final Short FROM_GOV=new Short("6");

        // VS = Verification Status
        public static final Short VS_COMPLETED=new Short("1000");
        public static final Short VS_REJECTED =new Short("1002");
        public static final Short VS_VERIFIED =new Short("1003");
        public static final Short VS_APPROVED =new Short("1004");
        public static final Short VS_CANCELLED =new Short("1005");
        public static final Short SAVE_AS_REJECTED =new Short("1006");

       /*Addition ends for OH Disease JYO*/
       /*Business Codes*/
        public static final Short NATIONALITY_CODE_SAUDI=new Short("1");

        /*Responsible for OH Payment.*/
        public static final Byte EST_RESPONSIBLE_OHBNFT=new Byte("1");
        public static final Byte CON_RESPONSIBLE_OHBNFT=new Byte("2");

        /*Addition for Transfer To Disease JYO*/
        public static final Short WFS_TRANS_DIS_PENDING_DATA_ENTRY=new Short("1000");
        public static final Short WFS_TRANS_DIS_ENTERED=new Short("1001");
        public static final Short WFS_TRANS_DIS_VERIFIED=new Short("1002");
        public static final Short WFS_TRANS_DIS_APPROVED_SUPERVISOR =new Short("1003");
        public static final Short WFS_TRANS_DIS_APPROVED_OH_DOC=new Short("1004");
        public static final Short WFS_TRANS_DIS_APPROVED_PMB_DOC=new Short("1005");
        public static final Short WFS_TRANS_DIS_APPROVED_OH_HEAD=new Short("1006");
        public static final Short WFS_TRANS_DIS_REJECTED=new Short("1007");
        public static final Short WFS_TRANS_DIS_REJECTED_SUPERVISOR =new Short("1008");
        public static final Short WFS_TRANS_DIS_REJECTED_OH_DOC=new Short("1009");
        public static final Short WFS_TRANS_DIS_REJECTED_PMB_DOC=new Short("1010");
        public static final Short WFS_TRANS_DIS_REJECTED_OH_HEAD=new Short("1011");
        public static final Short WFS_TRANS_DIS_APPROVED_HQ_DOC = new Short("1012");
        public static final Short WFS_TRANS_DIS_APPROVED_AMB_SECY = new Short("1013");
        public static final Short WFS_TRANS_DIS_REJECTED_HQ_DOC=new Short("1014");
        public static final Short WFS_TRANS_DIS_REJECTED_AMB_SECY=new Short("1015");
        /*Addition Ends for Transfer To Disease JYO*/

        // Need to check this ..... where ever used ....
        public static final Long PMBCLERKROLE=new Long("10029");
        public static final Long AMBCLERKROLE=new Long("10028");

        /* Added by MR for UnRegisteredHospitalInvoice on 01/04/2002 */

        /* Added by MR for RegisteredHospitalInvoice on 01/04/2002 */

        /* Added by Kiran for Medical Board*/
        public static final Short WFS_PENDING_DATA_ENTRY_HEIR_DISB=new Short("1000");
        public static final Short WFS_ENTERED_HEIR_DISB=new Short("1001");
        public static final Short WFS_VERIFIED_PMB_DOC_HEIR_DISB=new Short("1002");
        public static final Short WFS_APPROVED_PMB_SECRY_HEIR_DISB =new Short("1003");
        public static final Short WFS_APPROVED_SOC_AFFAIRS_HEIR_DISB=new Short("1004");
        public static final Short WFS_REJECTED_PMB_DOC_HEIR_DISB=new Short("1005");
        public static final Short WFS_REJECTED_PMB_SECRY_HEIR_DISB=new Short("1006");
        public static final Short WFS_REJECTED_SOC_AFFAIRS_HEIR_DISB=new Short("1007");
        public static final Short WFS_REJECTED_HEIR_DISB=new Short("1008");
        public static final Short WFS_APPEAL_OH_DISB_CLERK=new Short("1009");
        public static final Short WFS_APPEAL_NON_OH_DISB_CLERK=new Short("1009");
        public static final Short WFS_APPEAL_AGE_EST_CLERK=new Short("1009");
        public static final Short WFS_APPEAL_HEIR_DISB_CLERK=new Short("1009");
        public static final Short WFS_APP_APPEAL_OH_DISB=new Short("1010");
        public static final Short WFS_REJ_APPEAL_OH_DISB=new Short("1011");
        public static final Short WFS_APP_APPEAL_NON_OH_DISB=new Short("1010");
        public static final Short WFS_REJ_APPEAL_NON_OH_DISB=new Short("1011");
        public static final Short WFS_APP_APPEAL_AGE_EST=new Short("1010");
        public static final Short WFS_REJ_APPEAL_AGE_EST=new Short("1011");
        public static final Short WFS_APP_APPEAL_HEIR_DISB=new Short("1010");
        public static final Short WFS_REJ_APPEAL_HEIR_DISB=new Short("1011");
        /*&&&&&&&&&&&&&THE FOLLOWING TILL NEXT COMMENT WERE COPIED FROM SA295 OHConstants by Kiran on 4/3/2002 12:43 PM*/

        /* The value of SESSION_SCHEDULED has been changed from 0
        to 1 on 07-10-2002 by Kiran */

        public static final Short AID_APPL_ENTER=new Short("1000");
        public static final Short AID_APPL_REJ_SUPERVISOR=new Short("1001");
        public static final Short AID_APPL_REENTER_APP_CLERK=new Short("1002");
        public static final Short AID_APPL_REENTER_REJ_CLERK =new Short("1003");
        public static final Short AID_APPL_APPR_SUPERVISOR=new Short("1004");
        public static final Short AID_APPL_REJ_DOCTOR=new Short("1005");
        public static final Short AID_APPL_APPR_DOCTOR=new Short("1006");
        public static final Short AID_APPL_APPR_HEAD =new Short("1007");
        public static final Short AID_APPL_REJ_HEAD =new Short("1008");
        public static final Short AID_APPL_APPR_FODIR =new Short("1009");
        public static final Short AID_APPL_REJ_FODIR =new Short("1010");
        public static final String AID_APPLIANCE = "AID_APPLIANCE";
        public static final String APP_AID_APPLIANCE_SUPERVISOR = "APP_AID_APPLIANCE_SUPERVISOR";
        public static final String APP_AID_APPLIANCE_OHDOCTOR = "APP_AID_APPLIANCE_OHDOCTOR";
        public static final String APP_AID_APPLIANCE_OHHEAD = "APP_AID_APPLIANCE_OHHEAD";
        public static final String APP_AID_APPLIANCE_FOHEAD = "APP_AID_APPLIANCE_FOHEAD";
        public static final String REENTER_AID_APPLIANCE = "REENTER_AID_APPLIANCE";

        public static final Byte AIDDEPENDENT = new Byte("1");
        public static final Byte NOTAIDDEPENDENT = new Byte("2");

        public static final Short APPLIANCE_QUOTED = new Short("1001");
        public static final Short APPLIANCE_DELETED = new Short("1002");
        public static final Short APPLIANCE_APPROVED = new Short("1003");

        public static final Integer NO_OF_DAYS_VALIDATE_REPORT   =new Integer("7");


        public static final String APPR_PMB_SECRETARY = "APPR_PMB_SECRETARY";

        /*&&&&&&&&&&&&&&&&&&&&&&&&ADDITION BY KIRAN ENDS HERE&&&&&&&&&&&&&&&&&&&&&&&&*/
        /* ADDED BY JYOTHSNA ON 4/3/2002 12:53 PM*/
        public static final Byte ENGAGEMENT_STATUS_ACTIVE=new Byte("1");
        public static final Byte ENGAGEMENT_STATUS_INACTIVE=new Byte("0");

        public static final String REC_FROM_EMPLOYER="REC_FROM_EMPLOYER";
        public static final String APP_REC_FROM_EMP_SUPERVISOR="APP_REC_FROM_EMP_SUPERVISOR";
        public static final String APP_REC_FROM_EMP_OHHEAD="APP_REC_FROM_EMP_OHHEAD";
        public static final String REENTER_REC_FROM_EMP="REENTER_REC_FROM_EMP";
        public static final String SEARCH_REC_FROM_EMPLOYER="SEARCH_REC_FROM_EMPLOYER";

        /* Addition for Transfer OH Ends here */
        //denotes the payable to as Contributor in PaymentBankDetails Table
        public static final Short PAYEE_TYPE_CONTRIBUTOR = new Short ("1005");
        public static final Short PAYMENT_MODE_BANK_TRANSFER = new Short("1001");
        public static final Short PAYMENT_MODE_CHEQUE = new Short("1002");
        public static final Short PAYMENT_MODE_CHEQUE_OVERSEAS = new Short("1003");
        public static final Short PAYMENT_MODE_CHEQUE_AUTHORIZED_PERSON = new Short("1004");

        public static final Long ROUTE_TO_PMB_DOC = new Long("2");
        public static final Long ROUTE_TO_OH_HEAD = new Long("1");

        public static final Long ROUTE_TO_OH_CLERK = new Long("1");
        public static final Long ROUTE_TO_ESTABLISHMENT = new Long("2");
        public static final Long ROUTE_TO_HOSPITAL = new Long("3");

        public static final Long BACK_TO_LEVEL1 = new Long("1");
        public static final Long BACK_TO_LEVEL2 = new Long("2");

        public static final Byte CHEQUE_PAYMENT=new Byte("1");
        public static final Byte BANK_TRANS_PAYMENT=new Byte("2");
        public static final Byte CASH_PAYMENT=new Byte("3");

        public static final Byte AM=new Byte("0");
        public static final Byte PM=new Byte("1");

        public static final Short IS_RESCHEDULED = new Short("1");
        public static final Short IS_NOT_RESCHEDULED = new Short("0");

        public static final Byte HOSP_EVAL_GOOD=new Byte("0");
        public static final Byte HOSP_EVAL_AVERAGE=new Byte("1");
        public static final Byte HOSP_EVAL_BAD=new Byte("2");

        public static final Byte HOSP_EVAL_AVAILABLE=new Byte("1");
        public static final Byte HOSP_EVAL_NOT_AVAILABLE=new Byte("2");

        public static final Byte HOSP_EVAL_NEW=new Byte("1");
        public static final Byte HOSP_EVAL_OLD=new Byte("2");

        public static final Byte HOSP_EVAL_XRAY_SCAN=new Byte("1");
        public static final Byte HOSP_EVAL_CT_SCAN=new Byte("2");
        public static final Byte HOSP_EVAL_ULTRA_SCAN=new Byte("3");

        public static final Integer NO_DAYS_APPEAL=new Integer("21");

        /*Added for STC by Jyo*/
        public static final Integer NO_OF_DAYS_EMPLOYER  =new Integer("3");
        public static final Integer NO_OF_DAYS_HOSPITAL  =new Integer("10");

        /* Finance interface FOR STC*/
        public static final Short WFS_TRANS_OH_APPROVED_FIN_SEC_MGR=new Short("1007");
        public static final Short WFS_TRANS_OH_REJECTED_FIN_SEC_MGR=new Short("1008");

        /* Complication validation -15july for STC */
        public static final Integer DISABILITY_PERCENTAGE = new Integer("10");
        public static final String APPR_PMB_HEAD = "APPR_PMB_HEAD";
        /*  END OF JYO-STC*/

        public static final String REC_FROM_CONTRIBUTOR="REC_FROM_CONTRIBUTOR";
        public static final String APP_REC_FROM_CON_SUPERVISOR="APP_REC_FROM_CON_SUPERVISOR";
        public static final String APP_REC_FROM_CON_OHHEAD="APP_REC_FROM_CON_OHHEAD";
        public static final String REENTER_REC_FROM_CON="REENTER_REC_FROM_CON";

        public static final Short DAY_SUNDAY = new  Short("1000");
        public static final Short DAY_MONDAY = new  Short("1001");
        public static final Short DAY_TUEDAY = new  Short("1002");
        public static final Short DAY_WEDDAY = new  Short("1003");
        public static final Short DAY_THUDAY = new  Short("1004");
        public static final Short DAY_FRIDAY = new  Short("1005");
        public static final Short DAY_SATDAY = new  Short("1006");

        public static final Byte SES_MORN_HRS = new Byte("8");
        public static final Byte SES_MORN_MIN = new Byte("0");
        public static final Byte SES_EVEN_HRS = new Byte("12");
        public static final Byte SES_EVEN_MIN = new Byte("30");

        public static final Short WFS_CANC_WD_APPEAL_OH=new Short("1012");
        public static final Short WFS_CANC_WD_APPEAL_NON_OH=new Short("1012");
        public static final Short WFS_CANC_WD_APPEAL_HEIR_DISB=new Short("1012");
        public static final Short WFS_CANC_WD_APPEAL_AGE_EST=new Short("1012");

        public static final String APP_REC_FROM_EMP_FIN_SEC_MNGR="APP_REC_FROM_EMP_FIN_SEC_MNGR";
        public static final String APP_REC_FROM_EMP_FO_DIR="APP_REC_FROM_EMP_FO_DIR";

        public static final String APP_REC_FROM_CON_FIN_SEC_MNGR="APP_REC_FROM_CON_FIN_SEC_MNGR";
        public static final String APP_REC_FROM_CON_FO_DIR="APP_REC_FROM_CON_FO_DIR";

        //Added by Kiran for Assign MB Session GOSI HQ check
        public static final Short FIELD_OFFICE_GOSI_HQ=new Short("0");
        public static final Short FIELD_OFFICE_GOSI_RIYADH=new Short("1");

        /* Added by Jyothsna For Complication*/
        public static final String APPROVE_AMB_DOCTOR="APPROVE_AMB_DOCTOR";
        public static final String APPROVE_HO_DOCTOR="APPROVE_HO_DOCTOR";
        public static final Integer NO_OF_DAYS_TO_CALC=new Integer("365");
        public static final Double NO_OF_YRS_CALC=new Double("3.0");

        /* End of Jyo */
        /* Added By Roshan 27/08/2002 3:22 PM */
        /*Payment status of treatment serivce used in Table - T_TRMTSERVICESDET, DB FIELD  - PAYMENTSTATUS */
        public static final String  MED_CODE = "MED_CODE";
        public static final Short TRMT_SRVC_PAY_STS_PAID = new Short("1001");
        public static final Short TRMT_SRVC_PAY_STS_NOT_PAID = new Short("1000");
        public static final String OLD_LAW = "OLD_LAW";
        public static final String NEW_LAW = "NEW_LAW";

        public static final Short REGISTERED_HOSP=new Short("1001");

        public static final Byte STOP_ALLOWANCE_FLAG = new Byte("1");
        public static final Byte RESUME_ALLOWANCE_FLAG = new Byte("2");


        public static final Byte UNREG_HOSP_PAID_FLAG = new Byte("1");
        public static final Byte UNREG_HOSP_UNPAID_FLAG = new Byte("2");

        public static final Byte PAYMENT_WAIVE_FLAG = new Byte("1");
        public static final Byte PAYMENT_NOT_WAIVE_FLAG = new Byte("2");

        public static final Byte INJURY_NOTIFIED_BY_EMPLOYER = new Byte("1");
        public static final Byte INJURY_NOTIFIED_BY_HOSPITAL = new Byte("2");
        public static final Byte INJURY_NOTIFIED_BY_GOSI = new Byte("3");

        public static final Long RANGE_CAN_STOP_VALUE = new Long("0");
        public static final Long RANGE_CAN_CONTINUE_VALUE = new Long("1");

        //Total Disability Benefit status used in T_STOPRESUMEOHALLOWANCE Table. DB FIELD - STATUS.
        public static final Short STOP_ALLOW_STS_ENTERED  = new Short("1001");
        public static final Short STOP_ALLOW_STS_VERIFIED = new Short("1002");
        public static final Short STOP_ALLOW_STS_APPROVED = new Short("1003");
        public static final Short STOP_ALLOW_STS_REJECTED = new Short("1004");
        public static final Short STOP_ALLOW_STS_CANCELLED = new Short("1005");

        public static final Short WFS_STOP_ALLOW_ENTERED = new Short("1001");
        public static final Short WFS_STOP_ALLOW_REJECTED = new Short("1002");
        public static final Short WFS_STOP_ALLOW_VERIFIED_OH_SUPERVISOR = new Short("1003");
        public static final Short WFS_STOP_ALLOW_REJECTED_OH_SUPERVISOR = new Short("1004");
        public static final Short WFS_STOP_ALLOW_APPROVED_FO_DIR = new Short("1005") ;
        public static final Short WFS_STOP_ALLOW_REJECTED_FO_DIR = new Short("1006");
        public static final Short WFS_STOP_ALLOW_CANCELLED = new Short("1007");
        public static final Short WFS_STOP_ALLOW_CANCELLED_OH_SUPERVISOR = new Short("1008");
        public static final Short WFS_STOP_ALLOW_CANCELLED_FO_DIR = new Short("1009");

        public static final String ICD_MEDICINE_CODE = "ICDMED";
        public static final String ICD_SERVICE_CODE = "ICDSER";

        public static final Short NO_BENEFIT_VALUE = new Short("1000");
        public static final Short PENSION_BENEFIT_VALUE = new Short("1001");
        public static final Short LUMPSOME_BENEFIT_VALUE = new Short("1002");

        public static final Short WFS_SRVC_CANCELLED = new Short("1012");
        public static final Short WFS_SRVC_CANCELLED_OH_SUPERVISOR = new Short("1013");
        public static final Short WFS_SRVC_CANCELLED_OH_DOCTOR = new Short("1014");
        public static final Short WFS_SRVC_CANCELLED_OH_HEAD = new Short("1015");
        public static final Short WFS_SRVC_CANCELLED_HO_DOCTOR = new Short("1016");
        public static final Short WFS_SRVC_REJECTED_HO_DOC  =new Short("1017");
        public static final Short WFS_SRVC_APPROVED_HO_DOC  =new Short("1018");
        public static final Short WFS_SRVC_VERIFIED_HO_DOC  =new Short("1019");
        public static final Short WFS_SRVC_APPROVED_PMB_DOC =new Short("1020");
        public static final Short WFS_SRVC_REJECTED_PMB_DOC =new Short("1021");
        public static final Short WFS_SRVC_CANCELLED_PMB_DOC =new Short("1022");
        public static final Short WFS_SRVC_APPROVED_HQ_DOC  =new Short("1023");
        public static final Short WFS_SRVC_REJECTED_HQ_DOC  =new Short("1024");
        public static final Short WFS_SRVC_CANCELLED_HQ_DOC =new Short("1025");
        public static final Short WFS_SRVC_APPROVED_AMB_DOC =new Short("1026");
        public static final Short WFS_SRVC_REJECTED_AMB_DOC =new Short("1027");
        public static final Short WFS_SRVC_CANCELLED_AMB_DOC=new Short("1028");
        public static final Short WFS_SRVC_APPROVED_SA_MED=new Short("1029");
        public static final Short WFS_SRVC_REJECTED_SA_MED=new Short("1030");
        public static final Short WFS_SRVC_CANCELLED_SA_MED=new Short("1031");
        public static final Short WFS_SRVC_APPROVED_FO_DIR=new Short("1032");
        public static final Short WFS_SRVC_REJECTED_FO_DIR=new Short("1033");
        public static final Short WFS_SRVC_CANCELLED_FO_DIR=new Short("1034");

        public static final Short WFS_SRVC_APPROVED_SA_LEG=new Short("1035");
        public static final Short WFS_SRVC_REJECTED_SA_LEG=new Short("1036");
        public static final Short WFS_SRVC_CANCELLED_SA_LEG=new Short("1037");

        public static final Short WFS_SRVC_APPROVED_DY_GOV=new Short("1038");
        public static final Short WFS_SRVC_REJECTED_DY_GOV=new Short("1039");
        public static final Short WFS_SRVC_CANCELLED_DY_GOV=new Short("1040");

        public static final Short WFS_SRVC_APPROVED_GOV=new Short("1041");
        public static final Short WFS_SRVC_REJECTED_GOV=new Short("1042");
        public static final Short WFS_SRVC_CANCELLED_GOV=new Short("1043");

        public static final Byte HOSP_EVAL_GRADE_GOOD=new Byte("1");
        public static final Byte HOSP_EVAL_GRADE_ACCEPTED=new Byte("2");
        public static final Byte HOSP_EVAL_GRADE_NOT_ACCEPTED=new Byte("3");

        public Short MIN_FIELD_OFFICE_VALUE = new Short("0");
        public Short MAX_FIELD_OFFICE_VALUE = new Short("9999");

        public static final String MIN_INJURY_DATE = "01/01/1800";
        public static final String MAX_INJURY_DATE = "31/12/2200";


        /*  5-sept for transfer field office in move hosp*/
        public static final Short TRANSFER_REASON = new Short("1001");

        public static final Long RANGE_VALUE_HODOC=new Long("2");

        public static final Byte ROUTING_HODOC=new Byte("2");
        public static final Byte ROUTING_PMBDOC=new Byte("1");
        public static final Byte ROUTING_OHHEAD=new Byte("0");

        /* 11-SEPT for transfer to disease */
        public static final Short WFS_TRANS_DIS_CANCELLED_OH_CLERK=new Short("1012");
        public static final Short WFS_TRANS_DIS_CANCELLED_OH_SUPERVISOR=new Short("1013");
        public static final Short WFS_TRANS_DIS_CANCELLED_OH_DOCTOR=new Short("1014");
        public static final Short WFS_TRANS_DIS_CANCELLED_PMB_DOCTOR=new Short("1015");
        public static final Short WFS_TRANS_DIS_CANCELLED_OH_HEAD=new Short("1016");


        public static final Short WFS_TRANS_OH_CANCELLED_OH_CLERK=new Short("1009");
        public static final Short WFS_TRANS_OH_CANCELLED_OH_SUPERVISOR=new Short("1010");
        public static final Short WFS_TRANS_OH_CANCELLED_OH_HEAD=new Short("1011");
        public static final Short WFS_TRANS_OH_CANCELLED_FIN_SEC_MGR=new Short("1012");
        public static final Short WFS_TRANS_OH_CANCELLED=new Short("1013");

        /* Added for Move Hospitals on 13 sept*/
        public static final Byte AGREESTATUS_YES=new Byte("1");
        public static final Byte AGREESTATUS_NO=new Byte("0");

        //Added by Kiran for Governer Appeal and for Change Doctor Field Office
        public static final Short WFS_APP_GOV_OH=new Short("1013");
        public static final Short WFS_APP_GOV_NON_OH=new Short("1013");
        public static final Short WFS_APP_GOV_HEIR_DISB=new Short("1013");
        public static final Short WFS_APP_GOV_AGE_EST=new Short("1013");

        public static final Short WFS_REJ_GOV_OH=new Short("1014");
        public static final Short WFS_REJ_GOV_NON_OH=new Short("1014");
        public static final Short WFS_REJ_GOV_HEIR_DISB=new Short("1014");
        public static final Short WFS_REJ_GOV_AGE_EST=new Short("1014");

        public static final Byte ALL_DOCTORS = new Byte("0");
        public static final Byte SELECTED_DOCTORS = new Byte("1");

       /*  Added for Doctor Payment 20Sept*/
        public static final Short WFS_DOC_PAY_CANCELLED_PMB_CLERK=new Short("1009");
        public static final Short WFS_DOC_PAY_CANCELLED_PMB_HEAD=new Short("1010");
        public static final Short WFS_DOC_PAY_CANCELLED_FIN_MNGR=new Short("1011");
        public static final Short WFS_DOC_PAY_CANCELLED_FO_DIR=new Short("1012");

        public static final String APPR_DOC_PAY_FIN_MNGR ="APPR_DOC_PAY_FIN_MNGR";

        /*----------------------End --------------------------*/
        /*------------Addition from sa295 ohconstants by jyo on 29th sept-------*/

        //Added by kiran for Transfer OH
        public static final Byte HOSPITAL_TRANSFER_TYPE = new Byte("0");
        public static final Byte FIELDOFFICE_TRANSFER_TYPE = new Byte("1");

        /*-------------------------end of---------------------*/

        public static final Integer INJURYCHECKFORNOOFYEARS = new Integer("5");
        public static final Short LATEREPORTINGINJURY = new Short("1030");

        public static final Integer MAX_DAYS_FOR_SESSION_CREATION = new Integer("365");

        public static final Short DOC_NATIONALITY_SAUDI = new Short("1001");
        public static final Short DOC_NATIONALITY_NON_SAUDI = new Short("1001");

        public static final Byte RECOVERY_WAIVED = new Byte("1");
        public static final Byte RECOVERY_NOT_WAIVED = new Byte("0");

        public static final Short REC_FROM_EMP_WAIVED=new Short("1004");

        public static final Byte APPROVE_GOV_FLAG = new Byte("1");
        public static final Byte NOT_APPROVE_GOV_FLAG = new Byte("2");
        public static final Integer VALID_AMOUNT_PERCENT_RANGE = new Integer("20");

        /* For Inland Abroad check in Injury */
        public static final Short ABROADCONTRIBUTORREPORTING = new Short("1039");

        /* Added by Kiran for Medical Board */
        public static final Byte NEXT_ASSMT_YEAR_1 = new Byte("1");
        public static final Byte NEXT_ASSMT_YEAR_2 = new Byte("2");
        public static final Byte NEXT_ASSMT_YEAR_3 = new Byte("3");
        public static final Byte NEXT_ASSMT_YEAR_4 = new Byte("4");
        public static final Byte NEXT_ASSMT_YEAR_5 = new Byte("5");

        public static final Byte DISB_CONT_FOR_YEAR_1 = new Byte("1");
        public static final Byte DISB_CONT_FOR_YEAR_2 = new Byte("2");
        public static final Byte DISB_CONT_FOR_YEAR_3 = new Byte("3");
        public static final Byte DISB_CONT_FOR_YEAR_4 = new Byte("4");
        public static final Byte DISB_CONT_FOR_YEAR_5 = new Byte("5");

        /* Added by Nalini on 23-12-2002*/
        public static final Short WFS_TRANS_OH_APPROVED_FO_DIR = new Short("1013");
        public static final Short WFS_TRANS_OH_REJECTED_FO_DIR = new Short("1014");
        public static final Short WFS_TRANS_OH_CANCELLED_FO_DIR = new Short("1015");

        /* Added by Nalini on 08-01-2003*/
        public static final Byte ICD_10_INJURY_CATEGORY = new Byte("1");
        public static final Byte ICD_10_DISEASE_CATEGORY = new Byte("2");

        /** Added by roshan for Companion as trmt expense ..*/
        public static final String ICD_CODE_DOCTOR = "ICD_DOC";
        public static final String ICD_CODE_NURSE = "ICD_NUR";

        /** Added by Nalini on 11-01-2003 ..*/
        public static final Byte TRMT_DET_INACTIVE = new Byte("0");
        public static final Byte TRMT_DET_ACTIVE = new Byte("1");

        public static final Short CURRENCY_CODE_SAUDI_RIYAL = new Short("1");

        // EXCHANGERATE
        public static final Double EXCHANGE_RATE_SAUDI_RIYAL = new Double("1");


        //Exchange Rate Type
        public static final Short EXCHANGE_RATE_TYPE_CORPORATE=new Short("1001");
        public static final Short EXCHANGE_RATE_TYPE_DAILY=new Short("1002");
        public static final Short EXCHANGE_RATE_TYPE_USER_ENTERED=new Short("1003");
        public static final Short EXCHANGE_RATE_TYPE_NONE=new Short("1004");


        /** Added by Kiran on 16/01/2003 */
        public static final Integer MAX_ASSESSMENT_AGE = new Integer("60");

                // Added By Saad
                public static final Byte OH_REPORTS_16_01_0052_SAMPLE_1 = new Byte("1");
                public static final Byte OH_REPORTS_16_01_0052_SAMPLE_2= new Byte("2");

        /* Added by Roshan for Treatment Service */
        public static final String TRMT_SRVC_BULK_ENTRY = "COD_BLK";

        /* Following are added by Kiran for the scenario Reject OH Injury   */
        public static final Short WFS_REJ_OH_INJ_APPROVED = new Short("1001");
        public static final Short WFS_REJ_OH_INJ_REJEJECTED = new Short("1002");
        public static final Short WFS_REJ_OH_INJ_CANCELLED = new Short("1003");
        public static final Short WFS_REJ_OH_INJ_SAVEASREJECTED = new Short("1004");
        public static final Short WFS_REJ_OH_INJ_ENTRY = new Short("1005");
        public static final Short WFS_REJ_OH_INJ_APP_OH_HEAD = new Short("1006");
        public static final Short WFS_REJ_OH_INJ_REJ_OH_HEAD = new Short("1007");
        public static final Short WFS_REJ_OH_INJ_APP_FO_DIR = new Short("1008");
        public static final Short WFS_REJ_OH_INJ_REJ_FO_DIR = new Short("1009");
        public static final Short WFS_REJ_OH_INJ_APP_SOC_AFF = new Short("1010");
        public static final Short WFS_REJ_OH_INJ_REJ_SOC_AFF = new Short("1011");
        public static final Short WFS_REJ_OH_INJ_APP_DEP_GOV = new Short("1012");
        public static final Short WFS_REJ_OH_INJ_REJ_DEP_GOV = new Short("1013");
        public static final Short WFS_REJ_OH_INJ_REJ_GOV = new Short("1014");
        public static final Short WFS_REJ_OH_APP_REENTER = new Short("1015");

        public static final Short VS_SAVEASREJECTED =new Short("1006");
        /*  Adddition of values for Reject OH Injury ends here  */

        /* DMS Document types */
        public static final Short DMS_DOCTYPE_EMPLOYER_AFFAIRS_REPORT = new Short ("1221");
        public static final Short DMS_DOCTYPE_PASSPORT_COPY = new Short ("1222");

        //Additions of constants for DMS
        public static final String DMS_TRMT_SERVICE_WORKFLOW_ID = "Treatment Service Workflow Id";
        public static final String DMS_SESSION_NUMBER = "Session Number";
        public static final String DMS_INJURY_ID = "Injury Id";
        public static final String DMS_SERVICE_TYPE ="Service Type";
        public static final String DMS_MASTER_ID ="Master Id";
        public static final String DMS_WORKFLOW_ID ="Workflow Id";

        //Added by Akmal for Report Id's in Letters Starts.
        public static final String LET_9_OH_DEPT_TO_EST = "16_02_0002";
        public static final String LET_28_OH_DEPT_TO_EST = "16_02_0004";
        public static final String LET_13_OH_DEPT_TO_EST = "16_02_0003";
        public static final String LET_29_OH_DEPT_TO_EST = "16_02_0005";
        //Added by Akmal for Report Id's in Letters Ends.

        public static final Byte ASSESSMENT = new Byte("0");
        public static final Byte RE_ASSESSMENT = new Byte("1");

        public static final Short APPEALED=new Short((short)2);
        public static final Short NOT_APPEALED=new Short((short)1);
        public static final Short APPEAL_IN_PROGRESS=new Short((short)3);

        public static final Short COMPANION_TYPE_DOCTOR = new Short("1");
        public static final Short COMPANION_TYPE_NURSE  = new Short("2");
        public static final Short COMPANION_TYPE_OTHERS = new Short("3");

        /** Added by Kiran for Treatment Services Recover functionality on 17/01/2003 */
        public static final Byte TRMT_SRVS_NOT_RECOVERED = new Byte("0");
        public static final Byte TRMT_SRVS_RECOVERED_REG_HOSP = new Byte("1");
        public static final Byte TRMT_SRVS_RECOVERED_UNREG_HOSP = new Byte("2");
        public static final Byte TRMT_SRVS_RECOVERED_ALL = new Byte("3");

        // these value use in upload invoice by online
        public static final Short INVOICE_FILE_TYPE= new Short("1121");

        // these value use in upload invoice by online table T_FILEUPLOADINFO column FILESTATUS
        public static final Short INVOICE_FILE_STATUS_PENDING_ENTRY= new Short("1001");
        public static final Short INVOICE_FILE_STATUS_PENDING_VALIDATATION= new Short("1002");
        public static final Short INVOICE_FILE_STATUS_VALIDATED= new Short("1003");
        public static final Short INVOICE_FILE_STATUS_FAILD_WITH_ERROR= new Short("1004");
        public static final Short INVOICE_FILE_STATUS_FAILD= new Short("1005");


        /** Role Id */
        public static final Short ROLE_ID_FIELD_OFFICE_DIRECTOR          = new Short ("34");
        public static final Short ROLE_ID_OH_HEAD                        = new Short ("132");
        public static final Short ROLE_ID_OH_CLERK                       = new Short ("305");
        public static final Short ROLE_ID_OH_SUPERVISOR                  = new Short ("306");
        public static final Short ROLE_ID_DOCTOR                         = new Short ("307");
        public static final Short ROLE_ID_PMB_CLERK                      = new Short ("308");
        public static final Short ROLE_ID_PMB_SECRETARY                  = new Short ("309");
        public static final Short ROLE_ID_AMB_CLERK                      = new Short ("310");
        public static final Short ROLE_ID_AMB_SECRETARY                  = new Short ("311");
        public static final Short ROLE_ID_DOCTOR_HQ                      = new Short ("312");
        public static final Short ROLE_ID_INTERIOR_AUDIT_CLERK           = new Short ("316");
        public static final Short ROLE_ID_OH_ANALYST                     = new Short ("341");
        public static final Short ROLE_ID_MEDICAL_DEPARTMENT_MANAGER_HQ  = new Short ("377");
        public static final Short ROLE_ID_OH_HOPITAL_INVOICE_SUPERVISOR  = new Short ("538");
        public static final Short ROLE_ID_HOSPITAL_ADMIN                 = new Short ("641");
        public static final Short ROLE_ID_HOSPITAL_USER                  = new Short ("646");
        public static final Short ROLE_ID_OH_ESTABLISHMENT_CLERK         = new Short ("648");
        public static final Short ROLE_ID_GOSI_EMPLOYEE_EXTERNAL         = new Short ("658");
        public static final Short ROLE_ID_OH_CLERK_HQ                    = new Short ("1145");

    /*  Transaction ID's and respective Primary Key's in T_Workflowtxn table
        TxnID       PrimaryKey                Table

        101501  -   Injuryid                    - T_INJURY
        101502  -   Injuryid                    - T_INJURY
        101504  -   Injuryid                    - T_INJURY
        101505  -   Companionid                 - T_COMPANION
        101506  -   Trmtsrvcwrkfloid            - T_TRMTSERVICESDET
        101507  -   Injuryid                    - T_INJURY
        101508  -   Scheduleid                  - T_MBAPPOINTMENT
        101509  -   Injuryid                    - T_INJURY
        101510  -   Scheduleid                  - T_MBAPPOINTMENT
        101512  -   Workflowid                  - T_OHBENEFIT
        101513  -   Treatmentid                 - T_TREATMENT
        101514  -   Scheduleid                  - T_MBAPPOINTMENT
        101515  -   Scheduleid                  - T_MBAPPOINTMENT
        101516  -   Scheduleid                  - T_MBAPPOINTMENT
        101518  -   Scheduleid                  - T_MBAPPOINTMENT
        101522  -   Scheduleid                  - T_MBAPPOINTMENT
        101523  -   Doctorpaymentid             - T_DOCTORPAYMENT
        101524  -   Medicalboardbenefitid       - T_MBBENEFIT
        101525  -   Medicalboardbenefitid       - T_MBBENEFIT
        101530  -   Invoiceheaderid             - T_UNREGHOSPINVOICEHDR
        101531  -   Workflowid~Injuryid         - T_RECFROMEMP
        101532  -   Trmtsrvcwrkfloid            - T_TRMTSERVICESDET
        101533  -   Transferohid                - T_TRANSFEROH
        101534  -   Workflowid                  - T_RECFROMCONTRIBUTOR
        101535  -   Workflowid                  - T_STOPRESUMEOHALLOWANCE
        101536  -   Invoiceheaderid             - T_REGHOSPINVOICEHDR
        101553  -   Injuryid                    - T_INJURY
        101554  -   Settlementid                - T_OHDEATHSETTLEMENT
        101555  -   Disbsettlementid            - T_TOTALDISABILITY
        101557  -   Invoiceheaderid             - T_REGHOSPINVOICEHDR
        101558  -   Invoiceheaderid~pagenumber  - T_REGHOSPINVOICEHDR
        */


}