PREQ_FINANCIAL_RANK_DESC- The qualification status of the sub

Reply
Highlighted
White Belt

PREQ_FINANCIAL_RANK_DESC- The qualification status of the sub

What does each qualification status for the variable "PREQ_FINANCIAL_RANK_DESC" mean?

Is the "Financial Approval" part important for the security measurement?

We discovered 11 entries with "Failed to parse SST index '': java.lang.NumberFormatException: For input string: "" for "INC_BP_CODE" and  "PREQ_FINANCIAL_RANK_DESC"

Can we exclude the rows with those entries?

 

Thanks Smiley Happy


Accepted Solutions
Yellow Belt

Re: PREQ_FINANCIAL_RANK_DESC- The qualification status of the sub

See definitions below:

APPROVED-FINAL - Subcontractor has passed both safety and financial reviews

EXECUTIVE REJECTED - Subcontractor has been suspended from working on projects by the Executive Committee

FAILED TO PARSE SST...(BROKEN DATA I THINK) - I have no idea what this is from, it may be some issue with the dataset

PREQUAL EXPIRED - The subcontractor's prequalification is currently expired, they need to turn in financial and safety statistics for evaluation

PREQUAL INACTIVE > 90 DAYS - The subcontractor is currently inactive in our system (they have requested to not work or bid projects, or have not submitted statistics or had a contract issued for an extended period of time

SAFTEY APPROVED / NO FINANCIALS - Subcontractor has passed safety, but has not turned in any financial data (they are then given a small contract limit generally 100,000K)

SAFTEY CAP APPROVED / FINANCIAL APPROVED - Subcontractor is approved for work on a Safety Corrective Action Plan (CAP), and they are financially approved  

SAFTEY CAP APPROVED / FINANCIAL REJECTED - Subcontractor is approved to work on a Safety Corrective Action Plan (CAP) and they are financially rejected (depending on contract size they will either need to be bonded or some other type of financial situation will need to be addressed)

SAFTEY CAP APPROVED / NO FINANCIALS PROVIDED - Subcontractor is approved to work on a Safety Corrective Action Plan (CAP), but did not provide financials (so they are given a small total contract limit of 100,000K)

SAFTEY REJECTED / FINANCIAL APPROVED - Subcontractor is safety denied in the system, prior to issuing a contract they will need to work on a Corrective Action Plan (CAP), the subcontractor is approved financially

SAFTEY REJECTED / FINANCIAL REJECTED - Subcontractor is safety denied, prior to issuing a contract, they will need to work on a Corrective Action Plan (CAP), they are also financially rejected and will need to work on some sort of financial situation such as a bond prior to contract

SAFTEY REJECTED / NO FINANCIALS PROVIDED - Subcontractor is safety denied, prior to issuing a contract they will need to work on a Corrective Action Plan (CAP), they did not provide financials, so they are given the minimum limit (100,000K)

View solution in original post


All Replies
White Belt

Re: PREQ_FINANCIAL_RANK_DESC- The qualification status of the sub

I agree can someone please define these 12 unique values. They are important for sure as I think they represent the subcontracters saftey standing. 

 

APPROVED-FINAL

EXECUTIVE REJECTED

FAILED TO PARSE SST...(BROKEN DATA I THINK)

PREQUAL EXPIRED

PREQUAL INACTIVE > 90 DAYS

SAFTEY APPROVED / NO FINANCIALS

SAFTEY CAP APPROVED / FINANCIAL APPROVED

SAFTEY CAP APPROVED / FINANCIAL REJECTED

SAFTEY CAP APPROVED / NO FINANCIALS PROVIDED

SAFTEY REJECTED / FINANCIAL APPROVED

SAFTEY REJECTED / FINANCIAL REJECTED

SAFTEY REJECTED / NO FINANCIALS PROVIDED

 

 

Dojo Admin

Re: PREQ_FINANCIAL_RANK_DESC- The qualification status of the sub

@HeatherD can you assist here?

Dani aka "Mr.Dojo"

Dojo Admin
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
**You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.
Yellow Belt

Re: PREQ_FINANCIAL_RANK_DESC- The qualification status of the sub

See definitions below:

APPROVED-FINAL - Subcontractor has passed both safety and financial reviews

EXECUTIVE REJECTED - Subcontractor has been suspended from working on projects by the Executive Committee

FAILED TO PARSE SST...(BROKEN DATA I THINK) - I have no idea what this is from, it may be some issue with the dataset

PREQUAL EXPIRED - The subcontractor's prequalification is currently expired, they need to turn in financial and safety statistics for evaluation

PREQUAL INACTIVE > 90 DAYS - The subcontractor is currently inactive in our system (they have requested to not work or bid projects, or have not submitted statistics or had a contract issued for an extended period of time

SAFTEY APPROVED / NO FINANCIALS - Subcontractor has passed safety, but has not turned in any financial data (they are then given a small contract limit generally 100,000K)

SAFTEY CAP APPROVED / FINANCIAL APPROVED - Subcontractor is approved for work on a Safety Corrective Action Plan (CAP), and they are financially approved  

SAFTEY CAP APPROVED / FINANCIAL REJECTED - Subcontractor is approved to work on a Safety Corrective Action Plan (CAP) and they are financially rejected (depending on contract size they will either need to be bonded or some other type of financial situation will need to be addressed)

SAFTEY CAP APPROVED / NO FINANCIALS PROVIDED - Subcontractor is approved to work on a Safety Corrective Action Plan (CAP), but did not provide financials (so they are given a small total contract limit of 100,000K)

SAFTEY REJECTED / FINANCIAL APPROVED - Subcontractor is safety denied in the system, prior to issuing a contract they will need to work on a Corrective Action Plan (CAP), the subcontractor is approved financially

SAFTEY REJECTED / FINANCIAL REJECTED - Subcontractor is safety denied, prior to issuing a contract, they will need to work on a Corrective Action Plan (CAP), they are also financially rejected and will need to work on some sort of financial situation such as a bond prior to contract

SAFTEY REJECTED / NO FINANCIALS PROVIDED - Subcontractor is safety denied, prior to issuing a contract they will need to work on a Corrective Action Plan (CAP), they did not provide financials, so they are given the minimum limit (100,000K)

View solution in original post

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!