ebook img

2.2 Records: Alphabet G PDF

679 Pages·2008·5.22 MB·English
by  
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview 2.2 Records: Alphabet G

SECTION 2.2- RECORDS FOR ALPHABET G This section includes the record names, record descriptions, fields, and key of all records. The records that are used by the National Finance Center have an asterisk included. Records Description Fields Key *GARN_BALANCE Garnishment Balance BALANCE_ID KEY(3) BALANCE_PERIOD KEY(6) BALANCE_QTR KEY(5) BALANCE_YEAR KEY(4) BENEFIT_PLAN KEY(8) COMPANY KEY(2) DEDCD KEY(9) DED_CFEE_MTD DED_CFEE_QTD DED_CFEE_YTD DED_CLASS KEY(10) DED_GARN_MTD DED_GARN_QTD DED_GARN_YTD DED_MTD DED_PFEE_MTD DED_PFEE_QTD DED_PFEE_YTD DED_QTD DED_YTD EMPLID KEY(1) GARNID KEY(11) PLAN_TYPE KEY(7) GARN_DE_DED Garnishment DE Deductions BENEFIT_PLAN KEY(4) DEDCD KEY(5) DED_CLASS KEY(6) EFFDT KEY(2) GARN_DE_DEFNID KEY(1) PLAN_TYPE KEY(3) GARN_DE_DEFN Garnishment Dspable Earns Defn DECALC_SUBTR_CSP DECALC_SUBTR_FTX DECALC_SUBTR_LTX DECALC_SUBTR_STX DESCR DESCRLONG EFFDT KEY(2) EFF_STATUS GARN_DE_DEFNID KEY(1) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 1 MAINT_RESPONSBLTY TAX_BEN_IND GARN_DE_DEF_LNG Garnis. Dspable Earns Def Lang DESCR DESCRLONG EFFDT KEY(3) GARN_DE_DEFNID KEY(1) LANGUAGE_CD KEY(2) GARN_DE_EARN Garnishment DE Earnings Table EFFDT KEY(3) ERNCD KEY(4) GARN_RULE_ID KEY(2) INCLUD_EXCLUDE_IND STATE_GARN_LAW KEY(1) *GARN_EMPL_DED Garnish Employee Deductions BENEFIT_PLAN KEY(7) COMPANY KEY(2) DEDCD KEY(8) DED_CLASS KEY(9) DED_LIM_AMT DED_LIM_PCT EMPLID KEY(1) GARNID KEY(3) GARN_RULE_ID KEY(5) PLAN_TYPE KEY(6) STATE_GARN_LAW KEY(4) GARN_EXEMPT_TBL Garnishment Rules Exemptions EFFDT KEY(3) GARN_EX_ALW_AMT GARN_EX_AMT GARN_EX_CALC KEY(4) GARN_EX_DEP_AMT GARN_EX_DEP_EXCL GARN_EX_HRS GARN_EX_MAX GARN_EX_MIN GARN_EX_PCT GARN_RULE_ID KEY(2) GARN_VAR_FREQUENCY STATE_GARN_LAW KEY(1) GARN_OPERANDS Garnishment Operands EFFDT KEY(3) GARN_AMOUNT1 GARN_AMOUNT2 GARN_CALC_TYPE GARN_CONDITION GARN_ELEMENT1 GARN_ELEMENT2 GARN_OPERATOR EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 2 GARN_PERCENT1 GARN_PERCENT2 GARN_RULE_ID KEY(2) GARN_STEP KEY(4) GARN_STEP1 GARN_STEP2 STATE_GARN_LAW KEY(1) GARN_PAYEE_TMP Work Record for Garn Payee Tbl ADDRESS_SBR CONTACT_NAME DESCR GARN_PAYEE_ID KEY(1) GARN_PAYEE_NAME KEY(3) PHONE SEQNO KEY(2) GARN_PRORATE_DF Garnishment Prorate DF DESCRLONG GARN_PRORATE_RL_ID KEY(1) GARN_PRORATE_RL Garnishment Prorate RL DESCR DESCRLONG EFFDT KEY(3) GARN_PRORATE_RL_ID KEY(4) MAINT_RESPONSBLTY PRORATE_TYPE KEY(2) STATE_GARN_PRORATE KEY(1) *GARN_RULE Employee Garnishment Rule COMPANY KEY(2) EMPLID KEY(1) FORM_668W_YR GARNID KEY(3) GARN_ALLOW_CNT GARN_DED_SW GARN_DEP_EX_CNT GARN_EX_AMT GARN_EX_MAX GARN_EX_MIN GARN_RULE_ID KEY(5) GARN_VAR_FREQUENCY STATE_GARN_LAW KEY(4) GARN_RULE_LANG Garnishment Rules Def. RelLang DESCR DESCRLONG EFFDT KEY(4) GARN_RULE_ID KEY(2) LANGUAGE_CD KEY(3) STATE_GARN_LAW KEY(1) *GARN_RULE_TBL Garnishment Rules Definition DESCR DESCRLONG EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 3 EFFDT KEY(3) EFF_STATUS GARN_DE_DEFNID GARN_RULE_ID KEY(2) MAINT_RESPONSBLTY STATE_GARN_LAW KEY(1) *GARN_SCHED Employee Garnishment Schedule CMPNY_FEE_AMT CMPNY_FEE_PCT COMPANY KEY(2) EMPLID KEY(1) GARNID KEY(3) GARN_DED_AMT GARN_DED_CALC GARN_DED_PCT PAYEE_FEE_AMT PAYEE_FEE_PCT PAY_FREQUENCY KEY(4) PAY_PERIOD KEY(5) *GARN_SPEC Employee Garnishment Specification ADDRESS_SBR ADDRESS_SEQ_NUM AP_PAYMENT_DT_TYPE AUTO_CALC_STOP AUT_CALC_STOP_DAYS CMPNY_FEE_AMT CMPNY_FEE_PCT CMPNY_INCL_DE CMPNY_MTH_LIM_AMT COMPANY KEY(2) CONTACT_NAME COURT_DOC_ID COURT_DOC_ID2 COURT_NAME DEDCD DOC_RCVD_DT DOC_RCVD_HR DOC_RCVD_MN EMPLID KEY(1) GARNID KEY(3) GARN_DED_AMT GARN_DED_CALC GARN_DED_PCT GARN_DED_SCHED GARN_LIMIT_AMT GARN_LIMIT_BAL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 4 GARN_MTH_LIM_AMT GARN_PAYEE_NAME GARN_PRIORITY GARN_PRORATE_RL_ID GARN_REMARKS GARN_STATUS GARN_SUPPORT_TYPE GARN_TYPE GARN_VAR_FREQUENCY PAYEE_FEE_AMT PAYEE_FEE_PCT PAYEE_INCL_DE PAYEE_MTH_LIM_AMT PAY_MODE PHONE PRORATE_INEFF_SW PRORATE_OVRD_AMT PRORATE_OVRD_PCT RESP_REQ_DT RESP_REQ_HR RESP_REQ_MN SEPARATE_AP_PAYMNT SETID START_DT STATE_GARN_PRORATE STOP_DT VENDOR_ID GA_HOSPITAL_TBL GeoAccess Hospital Code TBL GA_HOSP_CODE KEY(1) GA_HOSP_NAME GA_LANGUAGE_TBL GeoAccess Language Code Tbl GA_LANG_CODE KEY(1) GA_LANG_NAME GA_MEDGRP_TBL GeoAccess MedicalGroup Codes GA_MEDG_CODE KEY(1) GA_MEDG_NAME GA_PRODUCT_TBL GeoAccess Product Code Table GA_PROD_CODE KEY(1) GA_PROD_NAME GA_PRV_ID GA Provider Id Record GA_PROD_CODE GA_PROD_NAME GA_ROLE_CODE GA_ROLE_NAME ORDER_SEQ KEY(1) PROVIDER_ID KEY(2) PROVIDER_ID_CHECK GA_PRV_OUTDOC GA Output of Providers ADDRESS60 CITY50 EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 5 DEGREE25 DISTANCE_IN_MILES FIRST_NAME50 LAST_NAME100 MIDDLE_NAME NAME NAME_SUFFIX NEW_PATIENTS ORDER_SEQ KEY(1) PHONE POSTAL POSTAL2 SEX STATE GA_PRV_PLANPROD PeopleSoft / GeoAccess Sync BENEFIT_PLAN KEY(2) EFFDT KEY(3) GA_PROD_CODE KEY(4) PLAN_TYPE KEY(1) GA_PRV_SETUP GeoAccess Setup Information GA_PRV_FILE_OPTION GA_PRV_MAP_OPTION GA_ROLE_TBL GeoAccess Role Code Table GA_ROLE_CODE KEY(1) GA_ROLE_NAME GA_SPECLTY_TBL GeoAccess Specialty Code Table GA_SPEC_CODE KEY(1) GA_SPEC_NAME GB_BINDVAL_TBL Group Build Bind Table EDITTABLE KEY(5) GB_EFFDT KEY(4) GB_GROUP_ID2 KEY(2) GB_VALUE LANGUAGE_CD PNLGRPNAME KEY(3) PROCESS_INSTANCE KEY(1) GB_BIND_TBL Group Build Bind Table GB_EFFDT KEY(4) GB_GROUP_ID2 KEY(2) GB_QRYNAME GB_RECNAME_RESULT GB_REFRESH_FLG PNLGRPNAME KEY(3) PROCESS_INSTANCE KEY(1) PROCESS_STATUS GB_CRITERIA_LNG Group Build - RelLang Table COMMENTS DESCR DESCRSHORT GB_CRITERIA_ID KEY(1) LANGUAGE_CD KEY(2) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 6 GB_CRITERIA_TBL Group Build - Group Criteria COMMENTS DESCR DESCRSHORT GB_CRITERIA_ID KEY(1) GB_FROMCRIT_TBL Group Build - Group Criteria EDITTABLE FIELDLABEL FIELDNAME GB_CRITERIA_ID KEY(1) GB_FROMCRIT_SW GROUP_BOOLEAN GROUP_LEFT_PAREN GROUP_RIGHT_PAREN OPERAND_SEQ KEY(2) RECNAME GB_GENERICWF Group Build Generic Workflow GB_EFFDT GB_GROUP_ID KEY(1) OPRID PNLGRPNAME VERSIONGBQDM KEY(2) WF_FLAG GB_GROUPTBL_LNG Rellang Group Build Main Tbl COMMENTS DESCR DESCRSHORT EFFDT KEY(3) GB_GROUP_ID KEY(1) LANGUAGE_CD KEY(2) *GB_GROUP_TBL Group Build Main Table APPROVER_ID COMMENTS COMPLEX_GROUP_FLG DESCR DESCRSHORT EFFDT KEY(2) EFF_STATUS GB_CRITERIA_ID GB_GROUP_ID KEY(1) LASTUPDDTTM MANAGER_ID QRYNAME SELF_SERVICE VERSION GB_GRP_RES_TBL Group Build - Std Result Table GB_GRP_RES_SBR GB_MERGEVAL_TBL Group Build Merging Table ADD_FLD1_NAME ADD_FLD1_VALUE ADD_FLD2_NAME EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 7 ADD_FLD2_VALUE ADD_FLD3_NAME ADD_FLD3_VALUE ADD_FLD4_NAME ADD_FLD4_VALUE GB_GROUP_ID KEY(3) GB_VALUE GB_VALUE_DT GB_VALUE_DTTM GB_VALUE_NBR KEY(5) GB_VALUE_TM LANGUAGE_CD OPERAND_SEQ KEY(4) PRCSINSTANCE KEY(1) QRYNAME KEY(2) GB_MERGE_TBL Group Build Merging Table BINDABLE_FLG EDITTABLE EFFDTOPERATOR_FLG GB_GROUP_ID KEY(3) GROUP_BOOLEAN GROUP_LEFT_PAREN GROUP_RIGHT_PAREN LFIELDNAME LRECNAME OPERAND_SEQ KEY(4) PRCSINSTANCE KEY(1) QRYNAME KEY(2) RFIELDNAME RRECNAME SQL_OPERATOR GB_PARM_VAL Group Build Bind Table EDITTABLE KEY(3) GB_GROUP_ID KEY(1) GB_VALUE VERSIONGBQDM KEY(2) GB_PLAN_SAL_WL Plan Salaries Worklist ACTIVITYNAME KEY(2) BUDGET_START_DT KEY(8) BUSPROCNAME KEY(1) DESCR50 EVENTNAME KEY(3) GB_GROUP_ID KEY(7) INSTANCEID KEY(5) TRANSACTIONID KEY(6) WORKLISTNAME KEY(4) GB_PLN_WL_LNG Rellang Plan Salaries Worklist ACTIVITYNAME KEY(2) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 8 BUDGET_START_DT KEY(8) BUSPROCNAME KEY(1) DESCR50 EVENTNAME KEY(3) GB_GROUP_ID KEY(7) INSTANCEID KEY(5) LANGUAGE_CD KEY(9) TRANSACTIONID KEY(6) WORKLISTNAME KEY(4) GB_PNLGRDFT_TBL Group Build PanelGroup Default PNLGRPNAME KEY(1) SYSTEM_DATA_FLG GB_SECGRPOPR_TB GB Security of Group Table EFFDT KEY(2) EFF_STATUS GB_GROUP_ID KEY(1) GB_OPRID KEY(3) GB_SECPNLG_TBL GB Security Table EFFDT KEY(2) GB_GROUP_ID KEY(1) GB_OPRID KEY(3) PNLGRPNAME KEY(4) GB_TMP_GB001 Group Build Batch Record EFFDT KEY(3) GB_GROUP_ID KEY(2) PRCSINSTANCE KEY(1) VERSION GB_VALUES_TBL Group Build Values Table ACTION ACTION_ITA BIRTHCOUNTRY COMPANY COUNTRY COUNTRY_OTHER CURRENCY_CD EFFDT KEY(2) EMPL_CTG EMPL_CTG_L1 GB_GROUP_ID KEY(1) GB_LANGUAGE_CD GB_VALUE GB_VALUE_DT GB_VALUE_DTTM GB_VALUE_TM GRADE LABOR_AGREEMENT OPERAND_SEQ KEY(3) OPRID PAYGROUP EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 9 SAL_ADMIN_PLAN SETID SETID_3 SETID_LOCATION TARIFF_GER TASKGROUP VALUE_SEQ KEY(4) GB_VERSION_MGMT GB Version Management CREATION_DT CREATION_TIME GB_BATCH_FLG GB_GROUP_ID KEY(1) GB_RECNAME_RESULT PROCESS_STATUS VERSION VERSIONGBQDM KEY(2) VERSIONQRYDDFN VERSIONQRYUDFN GB_WHERECRT_LNG GB Where Criteria Related lang FIELDLABEL FIELDNAME KEY(3) GB_CRITERIA_ID KEY(1) LANGUAGE_CD KEY(4) RECNAME KEY(2) GB_WHERECRT_TBL Group Build Where Criteria EDITTABLE FIELDLABEL FIELDNAME KEY(3) GB_CRITERIA_ID KEY(1) RECNAME KEY(2) GB_WHERE_TBL Group Build Where Clause Table EDITTABLE EFFDT KEY(2) FIELDLABEL FIELDNAME GB_FROMCRIT_SW GB_GROUP_ID KEY(1) GB_VALUES_LIST GROUP_BOOLEAN GROUP_LEFT_PAREN GROUP_RIGHT_PAREN OPERAND_SEQ KEY(3) RECNAME SQL_OPERATOR GDED_COM_DEF Genl deductions for a company COMPANY KEY(1) DEDCD KEY(3) EFFDT KEY(2) GDED_COM_TBL Genl deductions for a company COMPANY KEY(1) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.2 Records Alphabet G.doc P a ge | 10

Description:
Section 2.2 Records Alphabet G.doc. P a g e | 1. SECTION 2.2- RECORDS FOR ALPHABET G. This section Work Record for Garn Payee Tbl.
See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.