Retrieve JC Jobs By Code
    • 25 Sep 2024
    • 8 Minutes to read
    • Dark
      Light

    Retrieve JC Jobs By Code

    • Dark
      Light

    Article summary

    Get
    /jc-rest-api/rest/1/jcjob

    Query Standards

    Finder

    Following row finders are available for data filtering and optimizing request performance.

    • Select Job
    • Find By Keys
    • Select By Job Date
    • By UUID

    Select Job

    Recommended finder parameters. Refer to Query Parameters for example.

    ParameterDescriptionSample
    compCodeCompany Code001
    jobCodeVarJob Code0345
    jobDateJob Date2015-05-20
    costFlagCost FlagY

    Find By Keys

    This is an optional finder for querying Jobs by Company Code, Job Code, Control Job Code.

    ParameterDescriptionSample
    compCodeCompany Code001
    jobCodeVarJob Code0345
    ctrlJobCodeControl Job CodeALL

    Select By Job Date

    This is an optional finder for querying Jobs by Job Date.

    ParameterDescriptionSample
    jobDateJob Date2020-10-01

    By UUID

    This is an optional finder for querying a specific Job by row ID.

    ParameterDescriptionSample
    /VUUIDThe VUuid attribute is the Unique row ID/jc-rest-api/rest/1/jcjob/B41F55CA07F1A908E053B08610AC2C73
    Security
    HTTP
    Type basic

    Basic authentication

    Query parameters
    finder
    string
    ExampleselectJob;compCode=001,jobCodeVar=0345, jobDate=2015-05-20, costFlag=Y
    limit
    integer
    Example500
    offset
    integer
    Example0
    totalResults
    boolean
    Exampletrue
    orderBy
    string
    ExampleJobVUuid:desc
    Responses
    200

    OK

    Headers
    Content-Type
    string
    Exampleapplication/vnd.oracle.adf.resourcecollection+json
    example-0

    Successful Response - Finder - selectJob

    {
      "items": [
        {
          "JobAccmethCode": null,
          "JobAcctContactCode": null,
          "JobAcctPartnCode": null,
          "JobAcctPartnTypeCode": null,
          "JobActComplDate": null,
          "JobActStartDate": null,
          "JobActionCode": null,
          "JobAddTypeCode": null,
          "JobAdjBudgEqualsRevFlg": "N",
          "JobAllocApdiscJobFlag": "N",
          "JobAllowEtmshtEntriesFlag": "Y",
          "JobAllowOverheadFlag": "Y",
          "JobApTax1Code": null,
          "JobApTax2Code": null,
          "JobApTax3Code": null,
          "JobApplyDbRules": "N",
          "JobArTax1Code": null,
          "JobArTax2Code": null,
          "JobArTax3Code": null,
          "JobArchiveFlag": "N",
          "JobAreaDistrict": null,
          "JobAsstContactCode": null,
          "JobAsstPartnCode": null,
          "JobAsstPartnTypeCode": null,
          "JobAttachOraseq": 11282312,
          "JobAuthRqSeqNum": null,
          "JobBidCode": "14001B",
          "JobBidFlag": "N",
          "JobBidStatusCode": null,
          "JobBidSubmitDate": null,
          "JobBillAccCode": "40001",
          "JobBillAmt": 35787159.29,
          "JobBillDeptCode": "113",
          "JobBillFlag": null,
          "JobBillMethCode": "JB",
          "JobBillTblRevFcastFlg": "N",
          "JobBillingRateTableCode": "DFLT",
          "JobBillingTypeCode": "COST",
          "JobBudgOvrdProjFlag": "N",
          "JobBudgUnit": null,
          "JobBudgcstSameLevelFlag": "Y",
          "JobBudgrSeqNum": null,
          "JobCalSalChargeRate": null,
          "JobCcAccCode": "16010",
          "JobCcDeptCode": "113",
          "JobCertifyCode": null,
          "JobCertrepContractNumber": null,
          "JobCertrepEndDate": null,
          "JobCertrepFringeBenPaid": null,
          "JobCertrepSignatoryName": null,
          "JobCertrepSignatoryTitle": null,
          "JobCertrepStartDate": null,
          "JobChgSeqNum": null,
          "JobCilocCode": null,
          "JobCode": "14001",
          "JobCompCode": "001",
          "JobComplUnit": 0,
          "JobCompletedForWipFlag": null,
          "JobConstructionValue": null,
          "JobConstructionValuePct": null,
          "JobContTypeCode": null,
          "JobContactCode": null,
          "JobContractAmt": 30486604.95,
          "JobContractCode": "14001",
          "JobCostFlag": "Y",
          "JobCostMethCode": "B",
          "JobCostToComplOvrdFlg": "N",
          "JobCreateDate": "2015-05-20T07:19:57Z",
          "JobCtrlCode": "ALL",
          "JobCustCode": "ULV",
          "JobCustContactName": null,
          "JobDaysOutstInvPaidTtl": null,
          "JobDefaultDeptCode": "113",
          "JobDefaultPyovhdGrp": null,
          "JobDisbAmt": 0,
          "JobEqpChgNoRestartFlag": "N",
          "JobEstComplDate": "2019-08-30",
          "JobEstStartDate": "2018-01-01",
          "JobExclBillingWip": "N",
          "JobExclContAmtWipFlag": null,
          "JobExclRevBudgWip": "N",
          "JobExcludeFromWipFlag": null,
          "JobFcastInclSubjobsFlg": "N",
          "JobFinalizeProjectionsFlag": null,
          "JobFullyPaidInvs": null,
          "JobHbAmt": 0,
          "JobHbRecAmt": 0,
          "JobHier": "001     14001     ",
          "JobIbAllowFlag": "N",
          "JobIbExpenseCatCode": null,
          "JobIbFullTariffFlag": "N",
          "JobIgnoreCostsPriorToDate": null,
          "JobInvFormatCode": null,
          "JobInvoiceFormatCode": "2",
          "JobInvoiceGroupCode": null,
          "JobIuCreateDate": "2015-05-20T07:19:57Z",
          "JobIuUpdateDate": "2022-08-23T09:49:51Z",
          "JobJbMapCode": "DFLT",
          "JobJbRetainageCode": "DFLT",
          "JobJtrExpFlag": null,
          "JobLbcAccCode": null,
          "JobLbcDeptCode": null,
          "JobLocCode": null,
          "JobLongCode": null,
          "JobLstAddonDate": null,
          "JobLstRecDate": "2018-09-30",
          "JobLstRecPc": null,
          "JobLtcAccCode": "21010",
          "JobLtcDeptCode": "113",
          "JobMakeupFlag": null,
          "JobMaxBillingAmt": null,
          "JobMaxBillingBudgetAmt": null,
          "JobMaxChargePc": null,
          "JobMaxHourlyRate": null,
          "JobMaxHours": null,
          "JobMsCode": "EDU",
          "JobMutliOvhdPcFlag": "Y",
          "JobName": "1 ULV Facilities Upgrade",
          "JobOrigBudgetEffectiveDate": null,
          "JobOriginalContractAmt": 30394276.05,
          "JobOriginalFeeAmt": 15.75,
          "JobPartnCode": null,
          "JobPartnTypeCode": null,
          "JobPayFromJobCompFlag": "N",
          "JobPayrateScheduleCode": null,
          "JobPhsBudgUnitsFlag": "N",
          "JobPhsTypeRequiredFlg": "N",
          "JobPlPolicyNo": null,
          "JobPmFlag": null,
          "JobPolicyNo": null,
          "JobPrevailingWage": null,
          "JobProfrecAmt": null,
          "JobProjThresholdPct": 0,
          "JobPropertyId": null,
          "JobProvinceCode": null,
          "JobPublicSectorFlag": "N",
          "JobPwOvRate": null,
          "JobPwRateCode": null,
          "JobPyOvtruleCode": null,
          "JobRateByJobFlag": null,
          "JobRecAmt": 0,
          "JobReserveRevAccCode": "41011",
          "JobReserveRevDeptCode": "113",
          "JobRevenueGenState": "J",
          "JobRevrecAmt": null,
          "JobRevrecCurrDate": null,
          "JobRevrecLstAmt": 32492730.82,
          "JobRevrecLstPc": 10.2595,
          "JobRevrecPc": null,
          "JobRuleCode": "STANDARD",
          "JobSecGroup": null,
          "JobSectorCode": null,
          "JobShowCprAsCostAmtFlag": "N",
          "JobSiSeqNum": null,
          "JobSickPolicyCode": null,
          "JobSizeCode": "L",
          "JobStatusCode": "P",
          "JobSubFlag": null,
          "JobSuptContactCode": null,
          "JobSuptPartnCode": null,
          "JobSuptPartnTypeCode": null,
          "JobTax1Code": null,
          "JobTax2Code": null,
          "JobTax3Code": null,
          "JobTermCode": "NET30",
          "JobTrackRepBurden": null,
          "JobUeValidFlag": "Y",
          "JobUnbilledRevAccCode": "41009",
          "JobUnbilledRevDeptCode": "113",
          "JobUnitPricedContractFlag": "Y",
          "JobUseEqpBillRateFlag": "N",
          "JobUsePayBillRateFlag": "N",
          "JobWbsvCode1": null,
          "JobWbsvCode10": null,
          "JobWbsvCode11": null,
          "JobWbsvCode12": null,
          "JobWbsvCode2": null,
          "JobWbsvCode3": null,
          "JobWbsvCode4": null,
          "JobWbsvCode5": null,
          "JobWbsvCode6": null,
          "JobWbsvCode7": null,
          "JobWbsvCode8": null,
          "JobWbsvCode9": null,
          "JobWbsvEditableFlag1": "Y",
          "JobWbsvEditableFlag10": null,
          "JobWbsvEditableFlag11": null,
          "JobWbsvEditableFlag12": null,
          "JobWbsvEditableFlag2": "Y",
          "JobWbsvEditableFlag3": "Y",
          "JobWbsvEditableFlag4": "N",
          "JobWbsvEditableFlag5": null,
          "JobWbsvEditableFlag6": null,
          "JobWbsvEditableFlag7": null,
          "JobWbsvEditableFlag8": null,
          "JobWbsvEditableFlag9": null,
          "JobWbsvRequiredFlag1": "N",
          "JobWbsvRequiredFlag10": null,
          "JobWbsvRequiredFlag11": null,
          "JobWbsvRequiredFlag12": null,
          "JobWbsvRequiredFlag2": "N",
          "JobWbsvRequiredFlag3": "N",
          "JobWbsvRequiredFlag4": "N",
          "JobWbsvRequiredFlag5": null,
          "JobWbsvRequiredFlag6": null,
          "JobWbsvRequiredFlag7": null,
          "JobWbsvRequiredFlag8": null,
          "JobWbsvRequiredFlag9": null,
          "JobWipAccCode": null,
          "JobWipAdjAccCode": null,
          "JobWipAdjDeptCode": null,
          "JobWipDeptCode": "113",
          "JobWipLmrgOvrFlag": "N",
          "JobWipMrgLossbsAcc": null,
          "JobWipMrgLossbsDep": null,
          "JobWipMrgLossplAcc": null,
          "JobWipMrgLossplDep": null,
          "JobWipOhLossbsAcc": null,
          "JobWipOhLossbsDep": null,
          "JobWipOhLossplAcc": null,
          "JobWipOhLossplDep": null,
          "JobWipOverrideContAmt": null,
          "JobWipRollInSubjobFlag": "Y",
          "JobWipUnpostedCostAcc": null,
          "JobWipUnpostedCostCat": null,
          "JobWipUnpostedCostDep": null,
          "JobWipUnpostedCostPhase": null,
          "JobWipUnpostedRevAcc": null,
          "JobWipUnpostedRevCat": null,
          "JobWipUnpostedRevDep": null,
          "JobWipUnpostedRevPhase": null,
          "JobWmCode": null,
          "JobWoFlag": null,
          "JobWorkLoc": null,
          "WorkLoc": null,
          "JobVUuid": "B41F55C85A81A908E053B08610AC2C73",
          "links": [
            {
              "rel": "self",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcjob/B41F55C85A81A908E053B08610AC2C73",
              "name": "jcjob",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcjob/B41F55C85A81A908E053B08610AC2C73",
              "name": "jcjob",
              "kind": "item"
            }
          ]
        }
      ],
      "count": 1,
      "hasMore": true,
      "limit": 1,
      "offset": 0,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcjob",
          "name": "jcjob",
          "kind": "collection"
        }
      ]
    }
    example-1

    Successful Response - Finder - findByJobDate

    {
      "items": [
        {
          "JobAccmethCode": null,
          "JobAcctContactCode": null,
          "JobAcctPartnCode": null,
          "JobAcctPartnTypeCode": null,
          "JobActComplDate": null,
          "JobActStartDate": null,
          "JobActionCode": null,
          "JobAddTypeCode": null,
          "JobAdjBudgEqualsRevFlg": "N",
          "JobAllocApdiscJobFlag": null,
          "JobAllowEtmshtEntriesFlag": "Y",
          "JobAllowOverheadFlag": "Y",
          "JobApTax1Code": null,
          "JobApTax2Code": null,
          "JobApTax3Code": null,
          "JobApplyDbRules": null,
          "JobArTax1Code": null,
          "JobArTax2Code": null,
          "JobArTax3Code": null,
          "JobArchiveFlag": "N",
          "JobAreaDistrict": null,
          "JobAsstContactCode": null,
          "JobAsstPartnCode": null,
          "JobAsstPartnTypeCode": null,
          "JobAttachOraseq": 58,
          "JobAuthRqSeqNum": null,
          "JobBidCode": null,
          "JobBidFlag": "N",
          "JobBidStatusCode": null,
          "JobBidSubmitDate": null,
          "JobBillAccCode": "4000.100",
          "JobBillAmt": 1929.57,
          "JobBillDeptCode": "00",
          "JobBillFlag": null,
          "JobBillMethCode": "TM",
          "JobBillTblRevFcastFlg": "N",
          "JobBillingRateTableCode": null,
          "JobBillingTypeCode": null,
          "JobBudgOvrdProjFlag": "N",
          "JobBudgUnit": null,
          "JobBudgcstSameLevelFlag": "Y",
          "JobBudgrSeqNum": null,
          "JobCalSalChargeRate": null,
          "JobCcAccCode": "5200.200",
          "JobCcDeptCode": "00",
          "JobCertifyCode": null,
          "JobCertrepContractNumber": null,
          "JobCertrepEndDate": null,
          "JobCertrepFringeBenPaid": null,
          "JobCertrepSignatoryName": null,
          "JobCertrepSignatoryTitle": null,
          "JobCertrepStartDate": null,
          "JobChgSeqNum": null,
          "JobCilocCode": null,
          "JobCode": "ZZ-T&M",
          "JobCompCode": "ZZ",
          "JobComplUnit": null,
          "JobCompletedForWipFlag": null,
          "JobConstructionValue": null,
          "JobConstructionValuePct": null,
          "JobContTypeCode": null,
          "JobContactCode": null,
          "JobContractAmt": null,
          "JobContractCode": "ZZ-T&M",
          "JobCostFlag": "Y",
          "JobCostMethCode": "B",
          "JobCostToComplOvrdFlg": "N",
          "JobCreateDate": "2006-06-02T09:04:29Z",
          "JobCtrlCode": "ALL",
          "JobCustCode": "ZZ-ACME",
          "JobCustContactName": null,
          "JobDaysOutstInvPaidTtl": null,
          "JobDefaultDeptCode": null,
          "JobDefaultPyovhdGrp": null,
          "JobDisbAmt": null,
          "JobEqpChgNoRestartFlag": "N",
          "JobEstComplDate": "2000-03-15",
          "JobEstStartDate": "2000-01-01",
          "JobExclBillingWip": "N",
          "JobExclContAmtWipFlag": null,
          "JobExclRevBudgWip": "N",
          "JobExcludeFromWipFlag": null,
          "JobFcastInclSubjobsFlg": "N",
          "JobFinalizeProjectionsFlag": null,
          "JobFullyPaidInvs": null,
          "JobHbAmt": null,
          "JobHbRecAmt": null,
          "JobHier": "ZZ      ZZ-T&M    ",
          "JobIbAllowFlag": "N",
          "JobIbExpenseCatCode": null,
          "JobIbFullTariffFlag": "N",
          "JobIgnoreCostsPriorToDate": null,
          "JobInvFormatCode": "JCINV_CM",
          "JobInvoiceFormatCode": null,
          "JobInvoiceGroupCode": null,
          "JobIuCreateDate": null,
          "JobIuUpdateDate": "2022-08-17T05:07:44Z",
          "JobJbMapCode": null,
          "JobJbRetainageCode": null,
          "JobJtrExpFlag": null,
          "JobLbcAccCode": "9999",
          "JobLbcDeptCode": "00",
          "JobLocCode": null,
          "JobLongCode": null,
          "JobLstAddonDate": null,
          "JobLstRecDate": null,
          "JobLstRecPc": null,
          "JobLtcAccCode": "4000.400",
          "JobLtcDeptCode": "00",
          "JobMakeupFlag": "N",
          "JobMaxBillingAmt": null,
          "JobMaxBillingBudgetAmt": null,
          "JobMaxChargePc": null,
          "JobMaxHourlyRate": null,
          "JobMaxHours": null,
          "JobMsCode": null,
          "JobMutliOvhdPcFlag": "N",
          "JobName": "ZZ - Time and Materials Job",
          "JobOrigBudgetEffectiveDate": null,
          "JobOriginalContractAmt": null,
          "JobOriginalFeeAmt": null,
          "JobPartnCode": null,
          "JobPartnTypeCode": null,
          "JobPayFromJobCompFlag": "N",
          "JobPayrateScheduleCode": null,
          "JobPhsBudgUnitsFlag": "N",
          "JobPhsTypeRequiredFlg": "N",
          "JobPlPolicyNo": null,
          "JobPmFlag": "N",
          "JobPolicyNo": null,
          "JobPrevailingWage": "N",
          "JobProfrecAmt": null,
          "JobProjThresholdPct": 0,
          "JobPropertyId": null,
          "JobProvinceCode": null,
          "JobPublicSectorFlag": "N",
          "JobPwOvRate": null,
          "JobPwRateCode": null,
          "JobPyOvtruleCode": null,
          "JobRateByJobFlag": null,
          "JobRecAmt": null,
          "JobReserveRevAccCode": null,
          "JobReserveRevDeptCode": null,
          "JobRevenueGenState": "J",
          "JobRevrecAmt": null,
          "JobRevrecCurrDate": null,
          "JobRevrecLstAmt": null,
          "JobRevrecLstPc": null,
          "JobRevrecPc": null,
          "JobRuleCode": null,
          "JobSecGroup": null,
          "JobSectorCode": null,
          "JobShowCprAsCostAmtFlag": "N",
          "JobSiSeqNum": null,
          "JobSickPolicyCode": null,
          "JobSizeCode": "L",
          "JobStatusCode": "P",
          "JobSubFlag": null,
          "JobSuptContactCode": null,
          "JobSuptPartnCode": null,
          "JobSuptPartnTypeCode": null,
          "JobTax1Code": null,
          "JobTax2Code": null,
          "JobTax3Code": null,
          "JobTermCode": null,
          "JobTrackRepBurden": null,
          "JobUeValidFlag": "Y",
          "JobUnbilledRevAccCode": "4000.500",
          "JobUnbilledRevDeptCode": "00",
          "JobUnitPricedContractFlag": "N",
          "JobUseEqpBillRateFlag": "Y",
          "JobUsePayBillRateFlag": "N",
          "JobWbsvCode1": null,
          "JobWbsvCode10": null,
          "JobWbsvCode11": null,
          "JobWbsvCode12": null,
          "JobWbsvCode2": null,
          "JobWbsvCode3": null,
          "JobWbsvCode4": null,
          "JobWbsvCode5": null,
          "JobWbsvCode6": null,
          "JobWbsvCode7": null,
          "JobWbsvCode8": null,
          "JobWbsvCode9": null,
          "JobWbsvEditableFlag1": "N",
          "JobWbsvEditableFlag10": "N",
          "JobWbsvEditableFlag11": "N",
          "JobWbsvEditableFlag12": "N",
          "JobWbsvEditableFlag2": "N",
          "JobWbsvEditableFlag3": "Y",
          "JobWbsvEditableFlag4": "N",
          "JobWbsvEditableFlag5": "N",
          "JobWbsvEditableFlag6": "N",
          "JobWbsvEditableFlag7": "N",
          "JobWbsvEditableFlag8": "N",
          "JobWbsvEditableFlag9": "N",
          "JobWbsvRequiredFlag1": "N",
          "JobWbsvRequiredFlag10": "N",
          "JobWbsvRequiredFlag11": "N",
          "JobWbsvRequiredFlag12": "N",
          "JobWbsvRequiredFlag2": "N",
          "JobWbsvRequiredFlag3": "N",
          "JobWbsvRequiredFlag4": "N",
          "JobWbsvRequiredFlag5": "N",
          "JobWbsvRequiredFlag6": "N",
          "JobWbsvRequiredFlag7": "N",
          "JobWbsvRequiredFlag8": "N",
          "JobWbsvRequiredFlag9": "N",
          "JobWipAccCode": "5200.100",
          "JobWipAdjAccCode": null,
          "JobWipAdjDeptCode": null,
          "JobWipDeptCode": "00",
          "JobWipLmrgOvrFlag": "N",
          "JobWipMrgLossbsAcc": null,
          "JobWipMrgLossbsDep": null,
          "JobWipMrgLossplAcc": null,
          "JobWipMrgLossplDep": null,
          "JobWipOhLossbsAcc": null,
          "JobWipOhLossbsDep": null,
          "JobWipOhLossplAcc": null,
          "JobWipOhLossplDep": null,
          "JobWipOverrideContAmt": null,
          "JobWipRollInSubjobFlag": "N",
          "JobWipUnpostedCostAcc": null,
          "JobWipUnpostedCostCat": null,
          "JobWipUnpostedCostDep": null,
          "JobWipUnpostedCostPhase": null,
          "JobWipUnpostedRevAcc": null,
          "JobWipUnpostedRevCat": null,
          "JobWipUnpostedRevDep": null,
          "JobWipUnpostedRevPhase": null,
          "JobWmCode": null,
          "JobWoFlag": null,
          "JobWorkLoc": "ZSCH",
          "WorkLoc": null,
          "JobVUuid": "B5277CB44F4062B3E05313061FACC365",
          "links": [
            {
              "rel": "self",
              "href": "http://solutionsr12mob.cmicpaas.com:80/cmicprod/jc-rest-api/rest/1/jcjob/B5277CB44F4062B3E05313061FACC365",
              "name": "jcjob",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "http://solutionsr12mob.cmicpaas.com:80/cmicprod/jc-rest-api/rest/1/jcjob/B5277CB44F4062B3E05313061FACC365",
              "name": "jcjob",
              "kind": "item"
            }
          ]
        }
      ],
      "count": 1,
      "hasMore": true,
      "limit": 1,
      "offset": 0,
      "links": [
        {
          "rel": "self",
          "href": "http://solutionsr12mob.cmicpaas.com:80/cmicprod/jc-rest-api/rest/1/jcjob",
          "name": "jcjob",
          "kind": "collection"
        },
        {
          "rel": "action",
          "href": "http://solutionsr12mob.cmicpaas.com:80/cmicprod/jc-rest-api/rest/1/jcjob/action/assignCostCodesTemplate",
          "name": "assignCostCodesTemplate",
          "kind": "other"
        }
      ]
    }
    example-2

    Successful Response - Finder - findByKeys

    {
      "items": [
        {
          "JobAccmethCode": null,
          "JobAcctContactCode": null,
          "JobAcctPartnCode": null,
          "JobAcctPartnTypeCode": null,
          "JobActComplDate": null,
          "JobActStartDate": null,
          "JobActionCode": null,
          "JobAddTypeCode": null,
          "JobAdjBudgEqualsRevFlg": "N",
          "JobAllocApdiscJobFlag": "N",
          "JobAllowEtmshtEntriesFlag": "N",
          "JobAllowOverheadFlag": "Y",
          "JobApTax1Code": "QC",
          "JobApTax2Code": "GS",
          "JobApTax3Code": null,
          "JobApplyDbRules": "N",
          "JobArTax1Code": "QC",
          "JobArTax2Code": "GS",
          "JobArTax3Code": null,
          "JobArchiveFlag": "N",
          "JobAreaDistrict": null,
          "JobAsstContactCode": null,
          "JobAsstPartnCode": null,
          "JobAsstPartnTypeCode": null,
          "JobAttachOraseq": 267914931,
          "JobAuthRqSeqNum": null,
          "JobBidCode": null,
          "JobBidFlag": "N",
          "JobBidStatusCode": null,
          "JobBidSubmitDate": null,
          "JobBillAccCode": "40001",
          "JobBillAmt": null,
          "JobBillDeptCode": "00",
          "JobBillFlag": null,
          "JobBillMethCode": "JB",
          "JobBillTblRevFcastFlg": "N",
          "JobBillingRateTableCode": "DFLT",
          "JobBillingTypeCode": "COST",
          "JobBudgOvrdProjFlag": "N",
          "JobBudgUnit": null,
          "JobBudgcstSameLevelFlag": "Y",
          "JobBudgrSeqNum": null,
          "JobCalSalChargeRate": "N",
          "JobCcAccCode": "16010",
          "JobCcDeptCode": "00",
          "JobCertifyCode": "N",
          "JobCertrepContractNumber": null,
          "JobCertrepEndDate": null,
          "JobCertrepFringeBenPaid": null,
          "JobCertrepSignatoryName": null,
          "JobCertrepSignatoryTitle": null,
          "JobCertrepStartDate": null,
          "JobChgSeqNum": null,
          "JobCilocCode": null,
          "JobCode": "0345",
          "JobCompCode": "001",
          "JobComplUnit": null,
          "JobCompletedForWipFlag": "N",
          "JobConstructionValue": null,
          "JobConstructionValuePct": null,
          "JobContTypeCode": null,
          "JobContactCode": null,
          "JobContractAmt": 89162000,
          "JobContractCode": "0345",
          "JobCostFlag": "Y",
          "JobCostMethCode": "B",
          "JobCostToComplOvrdFlg": "N",
          "JobCreateDate": "2019-02-05T03:35:54Z",
          "JobCtrlCode": "ALL",
          "JobCustCode": "IRV",
          "JobCustContactName": null,
          "JobDaysOutstInvPaidTtl": null,
          "JobDefaultDeptCode": "00",
          "JobDefaultPyovhdGrp": null,
          "JobDisbAmt": null,
          "JobEqpChgNoRestartFlag": "N",
          "JobEstComplDate": null,
          "JobEstStartDate": null,
          "JobExclBillingWip": "N",
          "JobExclContAmtWipFlag": "N",
          "JobExclRevBudgWip": "N",
          "JobExcludeFromWipFlag": "N",
          "JobFcastInclSubjobsFlg": "N",
          "JobFinalizeProjectionsFlag": null,
          "JobFullyPaidInvs": null,
          "JobHbAmt": null,
          "JobHbRecAmt": null,
          "JobHier": "001     0345      ",
          "JobIbAllowFlag": "N",
          "JobIbExpenseCatCode": null,
          "JobIbFullTariffFlag": "N",
          "JobIgnoreCostsPriorToDate": null,
          "JobInvFormatCode": null,
          "JobInvoiceFormatCode": "CCDC",
          "JobInvoiceGroupCode": null,
          "JobIuCreateDate": "2019-02-05T03:35:55Z",
          "JobIuUpdateDate": "2023-07-25T04:59:56Z",
          "JobJbMapCode": "DFLT",
          "JobJbRetainageCode": "ZERO",
          "JobJtrExpFlag": "N",
          "JobLbcAccCode": null,
          "JobLbcDeptCode": null,
          "JobLocCode": null,
          "JobLongCode": null,
          "JobLstAddonDate": null,
          "JobLstRecDate": null,
          "JobLstRecPc": null,
          "JobLtcAccCode": "21010",
          "JobLtcDeptCode": "00",
          "JobMakeupFlag": null,
          "JobMaxBillingAmt": null,
          "JobMaxBillingBudgetAmt": null,
          "JobMaxChargePc": null,
          "JobMaxHourlyRate": null,
          "JobMaxHours": null,
          "JobMsCode": null,
          "JobMutliOvhdPcFlag": "Y",
          "JobName": "Fort St John Hospital",
          "JobOrigBudgetEffectiveDate": null,
          "JobOriginalContractAmt": 89162000,
          "JobOriginalFeeAmt": 0,
          "JobPartnCode": null,
          "JobPartnTypeCode": null,
          "JobPayFromJobCompFlag": "N",
          "JobPayrateScheduleCode": null,
          "JobPhsBudgUnitsFlag": "N",
          "JobPhsTypeRequiredFlg": "N",
          "JobPlPolicyNo": null,
          "JobPmFlag": "N",
          "JobPolicyNo": null,
          "JobPrevailingWage": "N",
          "JobProfrecAmt": null,
          "JobProjThresholdPct": 0,
          "JobPropertyId": null,
          "JobProvinceCode": null,
          "JobPublicSectorFlag": "N",
          "JobPwOvRate": null,
          "JobPwRateCode": null,
          "JobPyOvtruleCode": null,
          "JobRateByJobFlag": null,
          "JobRecAmt": null,
          "JobReserveRevAccCode": "41011",
          "JobReserveRevDeptCode": "00",
          "JobRevenueGenState": "J",
          "JobRevrecAmt": null,
          "JobRevrecCurrDate": null,
          "JobRevrecLstAmt": null,
          "JobRevrecLstPc": null,
          "JobRevrecPc": null,
          "JobRuleCode": null,
          "JobSecGroup": null,
          "JobSectorCode": null,
          "JobShowCprAsCostAmtFlag": "N",
          "JobSiSeqNum": null,
          "JobSickPolicyCode": null,
          "JobSizeCode": "L",
          "JobStatusCode": "P",
          "JobSubFlag": null,
          "JobSuptContactCode": null,
          "JobSuptPartnCode": null,
          "JobSuptPartnTypeCode": null,
          "JobTax1Code": null,
          "JobTax2Code": null,
          "JobTax3Code": null,
          "JobTermCode": "NET30",
          "JobTrackRepBurden": null,
          "JobUeValidFlag": "Y",
          "JobUnbilledRevAccCode": "41009",
          "JobUnbilledRevDeptCode": "00",
          "JobUnitPricedContractFlag": "N",
          "JobUseEqpBillRateFlag": "N",
          "JobUsePayBillRateFlag": "N",
          "JobWbsvCode1": null,
          "JobWbsvCode10": null,
          "JobWbsvCode11": null,
          "JobWbsvCode12": null,
          "JobWbsvCode2": null,
          "JobWbsvCode3": null,
          "JobWbsvCode4": null,
          "JobWbsvCode5": null,
          "JobWbsvCode6": null,
          "JobWbsvCode7": null,
          "JobWbsvCode8": null,
          "JobWbsvCode9": null,
          "JobWbsvEditableFlag1": "Y",
          "JobWbsvEditableFlag10": null,
          "JobWbsvEditableFlag11": null,
          "JobWbsvEditableFlag12": null,
          "JobWbsvEditableFlag2": "Y",
          "JobWbsvEditableFlag3": "Y",
          "JobWbsvEditableFlag4": "N",
          "JobWbsvEditableFlag5": null,
          "JobWbsvEditableFlag6": null,
          "JobWbsvEditableFlag7": null,
          "JobWbsvEditableFlag8": null,
          "JobWbsvEditableFlag9": null,
          "JobWbsvRequiredFlag1": "N",
          "JobWbsvRequiredFlag10": null,
          "JobWbsvRequiredFlag11": null,
          "JobWbsvRequiredFlag12": null,
          "JobWbsvRequiredFlag2": "N",
          "JobWbsvRequiredFlag3": "N",
          "JobWbsvRequiredFlag4": "N",
          "JobWbsvRequiredFlag5": null,
          "JobWbsvRequiredFlag6": null,
          "JobWbsvRequiredFlag7": null,
          "JobWbsvRequiredFlag8": null,
          "JobWbsvRequiredFlag9": null,
          "JobWipAccCode": null,
          "JobWipAdjAccCode": null,
          "JobWipAdjDeptCode": "00",
          "JobWipDeptCode": "00",
          "JobWipLmrgOvrFlag": "N",
          "JobWipMrgLossbsAcc": null,
          "JobWipMrgLossbsDep": null,
          "JobWipMrgLossplAcc": null,
          "JobWipMrgLossplDep": null,
          "JobWipOhLossbsAcc": null,
          "JobWipOhLossbsDep": null,
          "JobWipOhLossplAcc": null,
          "JobWipOhLossplDep": null,
          "JobWipOverrideContAmt": null,
          "JobWipRollInSubjobFlag": "Y",
          "JobWipUnpostedCostAcc": null,
          "JobWipUnpostedCostCat": null,
          "JobWipUnpostedCostDep": null,
          "JobWipUnpostedCostPhase": null,
          "JobWipUnpostedRevAcc": null,
          "JobWipUnpostedRevCat": null,
          "JobWipUnpostedRevDep": null,
          "JobWipUnpostedRevPhase": null,
          "JobWmCode": null,
          "JobWoFlag": null,
          "JobWorkLoc": null,
          "WorkLoc": null,
          "JobVUuid": "B41F55CA07F1A908E053B08610AC2C73",
          "links": [
            {
              "rel": "self",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcjob/B41F55CA07F1A908E053B08610AC2C73",
              "name": "jcjob",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcjob/B41F55CA07F1A908E053B08610AC2C73",
              "name": "jcjob",
              "kind": "item"
            }
          ]
        }
      ],
      "count": 1,
      "hasMore": false,
      "limit": 50,
      "offset": 0,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcjob",
          "name": "jcjob",
          "kind": "collection"
        }
      ]
    }
    object