<commit_before>-- View for Coeus compatibility 
DROP TABLE OSP$PROPOSAL;
CREATE OR REPLACE VIEW OSP$PROPOSAL AS SELECT 
    PROPOSAL_NUMBER, 
    SPONSOR_PROPOSAL_NUMBER, 
    SEQUENCE_NUMBER, 
    PROPOSAL_TYPE_CODE, 
    CURRENT_ACCOUNT_NUMBER, 
    TITLE, 
    SPONSOR_CODE, 
    ROLODEX_ID, 
    NOTICE_OF_OPPORTUNITY_CODE, 
    GRAD_STUD_HEADCOUNT, 
    GRAD_STUD_PERSON_MONTHS, 
    TYPE_OF_ACCOUNT, 
    ACTIVITY_TYPE_CODE, 
    REQUESTED_START_DATE_INITIAL, 
    REQUESTED_START_DATE_TOTAL, 
    REQUESTED_END_DATE_INITIAL, 
    REQUESTED_END_DATE_TOTAL, 
    TOTAL_DIRECT_COST_INITIAL, 
    TOTAL_DIRECT_COST_TOTAL, 
    TOTAL_INDIRECT_COST_INITIAL, 
    TOTAL_INDIRECT_COST_TOTAL, 
    NUMBER_OF_COPIES, 
    DEADLINE_DATE, 
    DEADLINE_TYPE, 
    MAIL_BY, 
    MAIL_TYPE, 
    MAIL_ACCOUNT_NUMBER, 
    SUBCONTRACT_FLAG, 
    COST_SHARING_INDICATOR, 
    IDC_RATE_INDICATOR, 
    SPECIAL_REVIEW_INDICATOR, 
    STATUS_CODE, 
    SCIENCE_CODE_INDICATOR, 
    NSF_CODE, 
    PRIME_SPONSOR_CODE, 
    CREATE_TIMESTAMP, 
    INITIAL_CONTRACT_ADMIN, 
    IP_REVIEW_REQ_TYPE_CODE, 
    REVIEW_SUBMISSION_DATE, 
    REVIEW_RECEIVE_DATE, 
    REVIEW_RESULT_CODE, 
    IP_REVIEWER, 
    IP_REVIEW_ACTIVITY_INDICATOR, 
    CURRENT_AWARD_NUMBER, 
    CFDA_NUMBER, 
    OPPORTUNITY, 
    UPDATE_TIMESTAMP, 
    UPDATE_USER, 
    AWARD_TYPE_CODE
FROM PROPOSAL;
<commit_msg>Release 2.0 sql updates.<commit_after>-- View for Coeus compatibility  
CREATE OR REPLACE VIEW OSP$PROPOSAL AS 
SELECT PROPOSAL_NUMBER,
       SPONSOR_PROPOSAL_NUMBER,
       SEQUENCE_NUMBER,
       PROPOSAL_TYPE_CODE,
       CURRENT_ACCOUNT_NUMBER,
       TITLE,
       SPONSOR_CODE,
       ROLODEX_ID,
       NOTICE_OF_OPPORTUNITY_CODE,
       GRAD_STUD_HEADCOUNT,
       GRAD_STUD_PERSON_MONTHS,
       TYPE_OF_ACCOUNT,
       ACTIVITY_TYPE_CODE,
       REQUESTED_START_DATE_INITIAL,
       REQUESTED_START_DATE_TOTAL,
       REQUESTED_END_DATE_INITIAL,
       REQUESTED_END_DATE_TOTAL,
       TOTAL_DIRECT_COST_INITIAL,
       TOTAL_DIRECT_COST_TOTAL,
       TOTAL_INDIRECT_COST_INITIAL,
       TOTAL_INDIRECT_COST_TOTAL,
       NUMBER_OF_COPIES,
       DEADLINE_DATE,
       DEADLINE_TYPE,
       MAIL_BY,
       MAIL_TYPE,
       MAIL_ACCOUNT_NUMBER,
       SUBCONTRACT_FLAG,
       COST_SHARING_INDICATOR,
       IDC_RATE_INDICATOR,
       SPECIAL_REVIEW_INDICATOR,
       STATUS_CODE,
       SCIENCE_CODE_INDICATOR,
       NSF_CODE,
       PRIME_SPONSOR_CODE,
       CREATE_TIMESTAMP,
       INITIAL_CONTRACT_ADMIN,
       IP_REVIEW_REQ_TYPE_CODE,
       REVIEW_SUBMISSION_DATE,
       REVIEW_RECEIVE_DATE,
       REVIEW_RESULT_CODE,
       IP_REVIEWER,
       IP_REVIEW_ACTIVITY_INDICATOR,
       CURRENT_AWARD_NUMBER,
       CFDA_NUMBER,
       OPPORTUNITY,
       UPDATE_TIMESTAMP,
       UPDATE_USER,
       AWARD_TYPE_CODE
FROM   PROPOSAL P,
       IP_REVIEW R
WHERE  P.PROPOSAL_NUMBER = R.PROPOSAL_NUMBER 
       AND R.IP_REVIEW_SEQUENCE_STATUS = 'ACTIVE';
{'fraction_non_alphanumeric': 0.04146838885112169, 'fraction_numerical': 0.0006798096532970768, 'mean_word_length': 2.8980132450331126, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1568992', 'n_tokens_mistral': 1252, 'n_tokens_neox': 1127, 'n_words': 141}