How-To: R FCQ Sequence

Owned by Vince Pete Darcangelo
Last updated: Feb 05, 2024
1 min read

Prepare R for files

Must have CIW access and R, R Studio and ROracle installed on your machine

  • Open R Studio

  • Run your version of ciwpass.R to activate your CIW credentials

Generate files in R

Open FCQ_Audit01.R

Make sure term_cd and semEndDt are correct.

  • Run FCQ_Audit01.R

  • There are built-in quality checks that will open new windows

    • If the new window is empty, continue running the code

    • If there are items that need to be addressed, follow the instructions in the code

Open FCQ_Audit02.R

This code establishes the general FCQ rules, determines eligibility and generates notes

  • Run FCQ_Audit02.R

  • There is a built-in quality check that will open a new window

    • If the new window is empty, continue running the code

    • If there are items that need to be addressed, follow the instructions in the code

Open FCQ_Audit03.R

  • If the dates, exceptions and custom questions are all accurate, run FCQ_Audit03.R

  • There are built-in quality checks that will open new windows

    • If the new window is empty, continue running the code

    • If there are items that need to be addressed, follow the instructions in the code

Open FCQ_Audit04.R

  • Make sure none of the current audit files are open

  • Run FCQ_Audit04.R

Open CL_Imports.R

  • Increase sess_num by 1 (and document in comments)

  • Update adminDtTxt variable in “session”

  • Run CL_Imports.R

  • There are built-in quality checks that will open new windows

    • If the new window is empty, continue running the code

    • If there are items that need to be addressed, follow the instructions in the code