<commit_before>#
# $Id: load_person_editable_fields.sql,v 1.3 2007-10-18 15:55:12 lprzybyl Exp $
#
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('fullName', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('emailAddress', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('userName', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('primaryTitle', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('directoryTitle', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('officePhone', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('homeUnit', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('school', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('faxNumber', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('eraCommonsUserName', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('pagerNumber', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('mobilePhoneNumber', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('officeLocation', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('secondaryOfficeLocation', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('addressLine1', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('addressLine2', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('addressLine3', sysdate, 'kradev');v
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('county', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('city', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('state', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('country', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('postalCode', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('percentageEffort', sysdate, 'kradev');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER) values ('faculty', sysdate, 'kradev');<commit_msg>KRACOEUS-520 Removing non-editable fields and adding active flag to data.<commit_after>#
# $Id: load_person_editable_fields.sql,v 1.4 2008-01-15 02:29:45 lprzybyl Exp $
#
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('emailAddress', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('primaryTitle', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('directoryTitle', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('officePhone', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('faxNumber', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('eraCommonsUserName', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('pagerNumber', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('mobilePhoneNumber', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('officeLocation', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('addressLine1', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('addressLine2', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('addressLine3', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('county', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('city', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('state', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('country', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('postalCode', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('percentageEffort', sysdate, 'kradev', 'Y');
insert into PERSON_EDITABLE_FIELDS (FIELD_NAME, UPDATE_TIMESTAMP, UPDATE_USER, ACTIVE_FLAG) values ('faculty', sysdate, 'kradev', 'Y');
{'fraction_non_alphanumeric': 0.11462256427050925, 'fraction_numerical': 0.006713607335844114, 'mean_word_length': 10.502824858757062, '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': '2556637', 'n_tokens_mistral': 2303, 'n_tokens_neox': 2089, 'n_words': 512}