518 lines
34 KiB
Plaintext
518 lines
34 KiB
Plaintext
|
|
Tables in MasterProjectDBUAT not used in the SQL of HRM.DA/DA
|
||
|
|
Generated 2026-11-10 Total: 510 of 989 tables
|
||
|
|
Note: HangFire.* tables are used by the Hangfire library itself - do not drop.
|
||
|
|
|
||
|
|
=== A. No reference anywhere in code or in DB procs/views/functions (467) ===
|
||
|
|
Table Rows
|
||
|
|
[dbo].[ACCESSCARDDEVICE] 0
|
||
|
|
[dbo].[ACHIVEMENTS] 0
|
||
|
|
[dbo].[ADBASIC] 0
|
||
|
|
[dbo].[ADParameterExcluding] 0
|
||
|
|
[dbo].[ALTERNATEAPPROVERSEMPLOYEE] 0
|
||
|
|
[dbo].[APACCESSIBLESBU-X] 0
|
||
|
|
[dbo].[APFUNCTION-X] 0
|
||
|
|
[dbo].[APGRADE-X] 0
|
||
|
|
[dbo].[APORGANOGRAM-X] 0
|
||
|
|
[dbo].[APPRAISALPOINTRATING-X] 0
|
||
|
|
[dbo].[APPRAISALPOINT-X] 0
|
||
|
|
[dbo].[APPRAISALRATINGSTATUS-X] 0
|
||
|
|
[dbo].[APPRAISALRATING-X] 0
|
||
|
|
[dbo].[APPRENTICESALARY-X] 0
|
||
|
|
[dbo].[APPROCESSSETUP-X] 0
|
||
|
|
[dbo].[APPROVEFINANTIALDATA-X] 2
|
||
|
|
[dbo].[APRECRUITMENTREQ-X] 0
|
||
|
|
[dbo].[APREQUISITION-X] 0
|
||
|
|
[dbo].[APSBU-X] 0
|
||
|
|
[dbo].[APSHORTLIST-X] 0
|
||
|
|
[dbo].[ARREARCORRECTION-X] 0
|
||
|
|
[dbo].[ARREARPROCESSDETAIL-x] 0
|
||
|
|
[dbo].[ASSESSMENTPROCESS] 0
|
||
|
|
[dbo].[ASSETTEMP-X] 0
|
||
|
|
[dbo].[ASSIGNPROXYOBJECTIVESETTING-X] 0
|
||
|
|
[dbo].[ATTENRAWDATA] 0
|
||
|
|
[dbo].[ATTNBLUEMORNINGDATA-X] 0
|
||
|
|
[dbo].[ATTNERAWDATA] 0
|
||
|
|
[dbo].[ATTNGREENEVENINGDATA-X] 0
|
||
|
|
[dbo].[ATTNWFHISTORY-X] 0
|
||
|
|
[dbo].[ATTNWHITENIGHTDATA-X] 0
|
||
|
|
[dbo].[ATTNYELLOWNIGHTDATA] 0
|
||
|
|
[dbo].[AUDITTRAIL] 0
|
||
|
|
[dbo].[AULEAVEDEDUCT] 0
|
||
|
|
[dbo].[AUTOPEDINGREMINDER] 0
|
||
|
|
[dbo].[AUTOREMINDERDETAILS] 0
|
||
|
|
[dbo].[AUTOREMINDERSETUP] 0
|
||
|
|
[dbo].[BANKGUARANTEE] 0
|
||
|
|
[dbo].[BENEFICIARYDETAIL] 0
|
||
|
|
[dbo].[BONUSINCENTIVE] 0
|
||
|
|
[dbo].[BONUSPARAMDATA] 0
|
||
|
|
[dbo].[BONUSPARAMDATAM] 0
|
||
|
|
[dbo].[BONUSPAYDETAIL] 0
|
||
|
|
[dbo].[BONUSPAYMENT] 0
|
||
|
|
[dbo].[BONUSPROCESSADJUSTITEM] 0
|
||
|
|
[dbo].[BONUSPROCESSCALCULATIONITEM] 0
|
||
|
|
[dbo].[BONUSPROCESSSALARYITEM] 0
|
||
|
|
[dbo].[BUDGETHEADS] 0
|
||
|
|
[dbo].[BUDGETPLANIND] 0
|
||
|
|
[dbo].[BUDGETPLANINDITEM] 0
|
||
|
|
[dbo].[BusinessLines] 13
|
||
|
|
[dbo].[BUYERDAILYATTPROCESS] 0
|
||
|
|
[dbo].[BUYERSETUP] 0
|
||
|
|
[dbo].[CBCANDIDATE] 0
|
||
|
|
[dbo].[CBDESIGNATION] 0
|
||
|
|
[dbo].[CBFUNCTION] 0
|
||
|
|
[dbo].[CBGRADE] 0
|
||
|
|
[dbo].[CBSBU] 0
|
||
|
|
[dbo].[COLUMNDEFINITION] 3
|
||
|
|
[dbo].[COMMONUSERS] 0
|
||
|
|
[dbo].[COMPARATOR] 0
|
||
|
|
[dbo].[CONTENTFLOWDETAIL] 0
|
||
|
|
[dbo].[CrestDef] 5
|
||
|
|
[dbo].[CrestDetail] 5
|
||
|
|
[dbo].[CREWDEPLOYTYPE] 0
|
||
|
|
[dbo].[CREWDEPLOYTYPEDETAIL] 0
|
||
|
|
[dbo].[CREWDEPLOYTYPEPOSITION] 0
|
||
|
|
[dbo].[CREWDEPPLANING] 0
|
||
|
|
[dbo].[CREWEMPLOYEE] 0
|
||
|
|
[dbo].[CRM_Activity] 0
|
||
|
|
[dbo].[CRM_AdditionalExpense] 0
|
||
|
|
[dbo].[CRM_AdditionalExpenseItem] 0
|
||
|
|
[dbo].[CRM_AITCategories] 1
|
||
|
|
[dbo].[CRM_AITSlabs] 0
|
||
|
|
[dbo].[CRM_AskForQuotationEmail] 0
|
||
|
|
[dbo].[CRM_BANKS] 0
|
||
|
|
[dbo].[CRM_BillAdvanceProcess] 0
|
||
|
|
[dbo].[CRM_BillOrAdvanceReceives] 0
|
||
|
|
[dbo].[CRM_BOMItem] 0
|
||
|
|
[dbo].[CRM_BOMs] 0
|
||
|
|
[dbo].[CRM_Bonus] 4
|
||
|
|
[dbo].[CRM_BOQHierarchy] 0
|
||
|
|
[dbo].[CRM_BOQHierarchyItem] 0
|
||
|
|
[dbo].[CRM_BOQs] 0
|
||
|
|
[dbo].[CRM_BPEmployeePermission] 0
|
||
|
|
[dbo].[CRM_BPLOCATIONHISTORY] 0
|
||
|
|
[dbo].[CRM_BPSUBTYPE] 0
|
||
|
|
[dbo].[CRM_BRANCHES] 0
|
||
|
|
[dbo].[CRM_BUSINESSPARTNERLOCATION] 0
|
||
|
|
[dbo].[CRM_Companies] 1
|
||
|
|
[dbo].[CRM_ContactPerson] 199
|
||
|
|
[dbo].[CRM_COUNTRIES] 0
|
||
|
|
[dbo].[CRM_CP] 541
|
||
|
|
[dbo].[CRM_CPBusinessPartner] 19498
|
||
|
|
[dbo].[CRM_CPFreeProductAlternateItem] 0
|
||
|
|
[dbo].[CRM_CPFreeProductItem] 61
|
||
|
|
[dbo].[CRM_CPInvoiceLineItem] 0
|
||
|
|
[dbo].[CRM_CPInvoiceSKU] 1101
|
||
|
|
[dbo].[CRM_CPMustLineItem] 0
|
||
|
|
[dbo].[CRM_CPSalesProgram] 436
|
||
|
|
[dbo].[CRM_CPSlab] 546
|
||
|
|
[dbo].[CRM_CPSlabCondition] 0
|
||
|
|
[dbo].[CRM_CreditLimitType] 9
|
||
|
|
[dbo].[CRM_DailyProduction] 0
|
||
|
|
[dbo].[CRM_DailyProductionDetail] 0
|
||
|
|
[dbo].[CRM_DailyProductionLossTime] 0
|
||
|
|
[dbo].[CRM_DailyProductionQC] 0
|
||
|
|
[dbo].[CRM_DailyProductionSkill] 0
|
||
|
|
[dbo].[CRM_DailyProductionSuperVisior] 0
|
||
|
|
[dbo].[CRM_Department] 25
|
||
|
|
[dbo].[CRM_Designation] 575
|
||
|
|
[dbo].[CRM_DispatchDetail] 0
|
||
|
|
[dbo].[CRM_DISTRICT] 0
|
||
|
|
[dbo].[CRM_EmployeeMarket] 2
|
||
|
|
[dbo].[CRM_EmployeePermission] 20
|
||
|
|
[dbo].[CRM_Employees] 2052
|
||
|
|
[dbo].[CRM_ExpenditureHead] 18
|
||
|
|
[dbo].[CRM_FASChartOfAccounts] 0
|
||
|
|
[dbo].[CRM_FASDetailParameter] 0
|
||
|
|
[dbo].[CRM_FASParamHierarchy] 0
|
||
|
|
[dbo].[CRM_FileManager] 891
|
||
|
|
[dbo].[CRM_FinancialRequesitionItem] 0
|
||
|
|
[dbo].[CRM_IDGenSchemes] 58
|
||
|
|
[dbo].[CRM_IncentiveCommission] 1
|
||
|
|
[dbo].[CRM_IncentiveDesignation] 2
|
||
|
|
[dbo].[CRM_InventoryTypes] 7
|
||
|
|
[dbo].[CRM_ItemGL] 0
|
||
|
|
[dbo].[CRM_LCSKUItems] 1569
|
||
|
|
[dbo].[CRM_MachineBDTrans] 0
|
||
|
|
[dbo].[CRM_MachineBDTranSpareParts] 0
|
||
|
|
[dbo].[CRM_MachineBreakDownType] 0
|
||
|
|
[dbo].[CRM_Machines] 0
|
||
|
|
[dbo].[CRM_MARKETHIERARCHYNODE] 0
|
||
|
|
[dbo].[CRM_MaterialConsumption] 0
|
||
|
|
[dbo].[CRM_MaterialConsumptionItems] 0
|
||
|
|
[dbo].[CRM_MaterialConsumptionItemSerials] 0
|
||
|
|
[dbo].[CRM_MaterialRequisitionItems] 31
|
||
|
|
[dbo].[CRM_MRpurposes] 12
|
||
|
|
[dbo].[CRM_Notifications] 9
|
||
|
|
[dbo].[CRM_Payments] 0
|
||
|
|
[dbo].[CRM_PrdAssembly] 31
|
||
|
|
[dbo].[CRM_PrdAssemblyDetail] 166
|
||
|
|
[dbo].[CRM_PrdRootSheet] 0
|
||
|
|
[dbo].[CRM_PrdRootSheetComponents] 0
|
||
|
|
[dbo].[CRM_PriceCategory] 9
|
||
|
|
[dbo].[CRM_PriorityDays] 0
|
||
|
|
[dbo].[CRM_ProductCategories_Backup] 51
|
||
|
|
[dbo].[CRM_ProductionLines] 0
|
||
|
|
[dbo].[CRM_ProductionLineSKU] 0
|
||
|
|
[dbo].[CRM_ProductionLineStageMachines] 0
|
||
|
|
[dbo].[CRM_ProductionLineStages] 0
|
||
|
|
[dbo].[CRM_ProductionLossTimeType] 0
|
||
|
|
[dbo].[CRM_ProductionStageQC] 0
|
||
|
|
[dbo].[CRM_ProductionStageQCDetail] 0
|
||
|
|
[dbo].[CRM_ProjectActivity] 0
|
||
|
|
[dbo].[CRM_ProjectActivityDependency] 0
|
||
|
|
[dbo].[CRM_ProjectActivityHistory] 0
|
||
|
|
[dbo].[CRM_ProjectBillSubmit] 0
|
||
|
|
[dbo].[CRM_ProjectBudget] 0
|
||
|
|
[dbo].[CRM_ProjectBudgetItem] 0
|
||
|
|
[dbo].[CRM_ProjectDeliveryOrderItem] 0
|
||
|
|
[dbo].[CRM_ProjectDocuments] 0
|
||
|
|
[dbo].[CRM_ProjectLocation] 0
|
||
|
|
[dbo].[CRM_Projects] 0
|
||
|
|
[dbo].[CRM_ProjectStatusHistory] 0
|
||
|
|
[dbo].[CRM_ProjectTypes] 2
|
||
|
|
[dbo].[CRM_RequisitionItems] 0
|
||
|
|
[dbo].[CRM_Requisitions] 0
|
||
|
|
[dbo].[CRM_RILProduction] 213
|
||
|
|
[dbo].[CRM_RILProductionItem] 4712
|
||
|
|
[dbo].[CRM_Sales_Challan] 3370
|
||
|
|
[dbo].[CRM_Sales_ChallanItem] 91
|
||
|
|
[dbo].[CRM_Sales_ChallanItemSerial] 19123
|
||
|
|
[dbo].[CRM_Sales_DeliveryOrder] 0
|
||
|
|
[dbo].[CRM_SalesDeliveryOrderWorkOrder] 0
|
||
|
|
[dbo].[CRM_SalesInvoice] 0
|
||
|
|
[dbo].[CRM_SalesWorkOrder] 0
|
||
|
|
[dbo].[CRM_SectionDetails] 99
|
||
|
|
[dbo].[CRM_ServicePackages] 3
|
||
|
|
[dbo].[CRM_Shifts] 1
|
||
|
|
[dbo].[CRM_Showroom] 38
|
||
|
|
[dbo].[CRM_ShowroomEmployee] 1159
|
||
|
|
[dbo].[CRM_SkillCategory] 0
|
||
|
|
[dbo].[CRM_SKUBatch] 0
|
||
|
|
[dbo].[CRM_SKUBatchStock] 0
|
||
|
|
[dbo].[CRM_SKUBatchStockSerial] 0
|
||
|
|
[dbo].[CRM_SKUChildren] 0
|
||
|
|
[dbo].[CRM_SKURelatedBP] 0
|
||
|
|
[dbo].[CRM_SKUSerial] 0
|
||
|
|
[dbo].[CRM_SKUStock] 0
|
||
|
|
[dbo].[CRM_SKUStoreLocations] 0
|
||
|
|
[dbo].[CRM_StageDetails] 0
|
||
|
|
[dbo].[CRM_Stages] 0
|
||
|
|
[dbo].[CRM_StockAdjustmentRegion] 0
|
||
|
|
[dbo].[CRM_StockTranItems] 0
|
||
|
|
[dbo].[CRM_StoreLocation] 0
|
||
|
|
[dbo].[CRM_TaxInfo] 0
|
||
|
|
[dbo].[CRM_Tender] 0
|
||
|
|
[dbo].[CRM_THANA] 0
|
||
|
|
[dbo].[CRM_TransactionApproval] 43
|
||
|
|
[dbo].[CRM_TransactionConditionInfo] 0
|
||
|
|
[dbo].[CRM_TransactionsType] 34
|
||
|
|
[dbo].[CRM_TransferWastage] 0
|
||
|
|
[dbo].[CRM_TransferWastageItem] 0
|
||
|
|
[dbo].[CRM_TransferWastageSuperVisior] 0
|
||
|
|
[dbo].[CRM_Unit] 0
|
||
|
|
[dbo].[CRM_USBlocation] 26
|
||
|
|
[dbo].[CRM_Users] 790
|
||
|
|
[dbo].[CRM_UserStores] 4
|
||
|
|
[dbo].[CRM_vwProjectActivity] 0
|
||
|
|
[dbo].[CRM_WorkOrder] 0
|
||
|
|
[dbo].[CRM_WorkOrderBillReceive] 0
|
||
|
|
[dbo].[CRM_WorkOrderbillSubmitDetail] 0
|
||
|
|
[dbo].[CRM_WorkOrderItem] 0
|
||
|
|
[dbo].[CVACADEMICQUALIFICATION] 0
|
||
|
|
[dbo].[CVEXPERIENCEINFORMATION] 0
|
||
|
|
[dbo].[CVOTHERREFERENCE] 0
|
||
|
|
[dbo].[CVPERSONALINFORMATION] 0
|
||
|
|
[dbo].[CVPREFEREDWORKAREA] 0
|
||
|
|
[dbo].[CVPREFERREDWORKAREA] 0
|
||
|
|
[dbo].[CVPROFESSIONALQUALIFICATION] 0
|
||
|
|
[dbo].[CVSKILLSACHEIVEMENT] 0
|
||
|
|
[dbo].[CVSKILLSACHIEVEMENT] 0
|
||
|
|
[dbo].[CVSOURCEOFAPPLICATION] 0
|
||
|
|
[dbo].[CVSOURSEOFAPPLICATION] 0
|
||
|
|
[dbo].[CVTRAININGINFORMATION] 0
|
||
|
|
[dbo].[DACHARGESHEET] 20
|
||
|
|
[dbo].[DACOMMEMP] 0
|
||
|
|
[dbo].[DAEMPLOYEES] 0
|
||
|
|
[dbo].[DailyAttProcessing] 0
|
||
|
|
[dbo].[DBFOREIGNKEYS] 0
|
||
|
|
[dbo].[DBPRIMARYKEYS] 0
|
||
|
|
[dbo].[DEFAULTCREWASSIGNMENT] 0
|
||
|
|
[dbo].[DEFAULTVALUE] 0
|
||
|
|
[dbo].[DELETED_EMPLIFECYCLE] 0
|
||
|
|
[dbo].[depttran] 389
|
||
|
|
[dbo].[DESTINATIONLEGEND] 0
|
||
|
|
[dbo].[DISCIPLINARYACTION] 0
|
||
|
|
[dbo].[DLP] 4
|
||
|
|
[dbo].[DOTTEDLINEPARENT] 148
|
||
|
|
[dbo].[EETEMP] 0
|
||
|
|
[dbo].[EMAILGROUP] 0
|
||
|
|
[dbo].[EMAILGROUPEMPLOYEE] 0
|
||
|
|
[dbo].[EMAILNOTIFICATIONDETAIL] 0
|
||
|
|
[dbo].[EMAILRECEIVER] 0
|
||
|
|
[dbo].[EMPAPPRAISAL] 0
|
||
|
|
[dbo].[EMPHOURDAYS] 0
|
||
|
|
[dbo].[EMPKRADETAIL] 0
|
||
|
|
[dbo].[EMPKRAOTHSTD] 0
|
||
|
|
[dbo].[EMPLIFECYCLEHISTORY] 0
|
||
|
|
[dbo].[EMPLOYEEAUDITTRAIL] 0
|
||
|
|
[dbo].[EMPLOYEEREPORTEXT] 0
|
||
|
|
[dbo].[EMPLOYEEtempt] 307
|
||
|
|
[dbo].[EMPMOBILEATTENDANCE] 0
|
||
|
|
[dbo].[EMPNODEHISTORY] 1
|
||
|
|
[dbo].[EMPSKILLLEVEL] 0
|
||
|
|
[dbo].[EMPTRAININGTEMP] 0
|
||
|
|
[dbo].[EQUATION] 0
|
||
|
|
[dbo].[EQUATIONDETAIL] 0
|
||
|
|
[dbo].[ERRORLOGGER] 0
|
||
|
|
[dbo].[EX2-X] 0
|
||
|
|
[dbo].[EXTERNALJOBPOSTING] 0
|
||
|
|
[dbo].[EX-X] 0
|
||
|
|
[dbo].[FACTORYWORKINGDESIGNATION] 0
|
||
|
|
[dbo].[FACTORYWORKSPACE] 0
|
||
|
|
[dbo].[FASGrade] 0
|
||
|
|
[dbo].[FASHead] 0
|
||
|
|
[dbo].[FASHeadItem] 0
|
||
|
|
[dbo].[FINANCIALAPPROVE] 0
|
||
|
|
[dbo].[FSTRANSACTION] 0
|
||
|
|
[dbo].[FSTRANSACTIONDETAIL] 0
|
||
|
|
[dbo].[FTEs] 1
|
||
|
|
[dbo].[GAP] 0
|
||
|
|
[dbo].[GENERALNEWS] 4
|
||
|
|
[dbo].[GENERALNOTICE] 257
|
||
|
|
[dbo].[GiftRequest] 17
|
||
|
|
[dbo].[GratuityInterest] 0
|
||
|
|
[dbo].[GROUPACHIVEMENT] 0
|
||
|
|
[dbo].[GROUPPERMISSION] 663
|
||
|
|
[dbo].[GUARANTORINFORMATION] 0
|
||
|
|
[dbo].[GUARANTYDOCUMENTCATEGORY] 0
|
||
|
|
[dbo].[HC] 0
|
||
|
|
[dbo].[HOSPITALIZATION] 0
|
||
|
|
[dbo].[HRDATAUPLOAD] 0
|
||
|
|
[dbo].[HRFUNCTION] 31
|
||
|
|
[dbo].[HRREQUEST] 0
|
||
|
|
[dbo].[HRREQUESTDETAIL] 0
|
||
|
|
[dbo].[HRREQUESTLOAN] 0
|
||
|
|
[dbo].[HRREQUESTLOANDETAIL] 0
|
||
|
|
[dbo].[HRREQUESTPASSPORT] 0
|
||
|
|
[dbo].[HRREQUESTPAYMENTSCHEDULE] 0
|
||
|
|
[dbo].[IDP] 0
|
||
|
|
[dbo].[IDPCHILD] 0
|
||
|
|
[dbo].[IDPMASTERFINAL] 0
|
||
|
|
[dbo].[INTERESTEDEMPLOYEE] 0
|
||
|
|
[dbo].[INTERNALJOBPOSTING] 0
|
||
|
|
[dbo].[INTERVIEWBOARD] 0
|
||
|
|
[dbo].[JCCALENDAR-X] 8
|
||
|
|
[dbo].[JobCategorys] 6
|
||
|
|
[dbo].[JobGrades] 1
|
||
|
|
[dbo].[JOININGASSESSMENT] 0
|
||
|
|
[dbo].[JVLOANTYPE] 0
|
||
|
|
[dbo].[KRASECTIONB-X] 0
|
||
|
|
[dbo].[LANGUAGES] 0
|
||
|
|
[dbo].[LAPTOPTEMP-X] 0
|
||
|
|
[dbo].[LegalTracking-X] 2
|
||
|
|
[dbo].[LOANEMPLOYEEDOC] 0
|
||
|
|
[dbo].[LOANSALARYADVANCE] 0
|
||
|
|
[dbo].[LOCALFUNCTION] 0
|
||
|
|
[dbo].[LOCTEMP] 0
|
||
|
|
[dbo].[LongServiceAwardChild-X] 82
|
||
|
|
[dbo].[LongServiceAwardMaster-X] 1
|
||
|
|
[dbo].[LTABASIC-X] 0
|
||
|
|
[dbo].[LTABENEFIT-X] 0
|
||
|
|
[dbo].[LTASETUP-X] 0
|
||
|
|
[dbo].[LTINCENTIVEPLAN-X] 0
|
||
|
|
[dbo].[MailComponent] 1112
|
||
|
|
[dbo].[MARKETSURVEYDETAIL] 0
|
||
|
|
[dbo].[MASTERKPI] 0
|
||
|
|
[dbo].[MEALDEDUCTIONSETUP] 0
|
||
|
|
[dbo].[MOBILELIST] 0
|
||
|
|
[dbo].[MOD_GROUP] 0
|
||
|
|
[dbo].[MODULEWISEKPI] 0
|
||
|
|
[dbo].[MONTHLYEMPLOYEEEXPENSE] 0
|
||
|
|
[dbo].[MONTHRANGE] 0
|
||
|
|
[dbo].[NetSalar-X] 158
|
||
|
|
[dbo].[NODERESPONSIBILITY] 0
|
||
|
|
[dbo].[NODESKILLLEVEL] 0
|
||
|
|
[dbo].[NOTIFICATIONPARTICIPANT] 0
|
||
|
|
[dbo].[NotificationReadLog] 0
|
||
|
|
[dbo].[NOTIFICATIONRULE] 0
|
||
|
|
[dbo].[NOTIFICATIONSETUP] 0
|
||
|
|
[dbo].[NULLTABLE] 0
|
||
|
|
[dbo].[OPIPARAMETERBASIC] 1
|
||
|
|
[dbo].[OPIPARAMETEREMPLOYEE] 0
|
||
|
|
[dbo].[ORGANOGRAMHISTORY] 0
|
||
|
|
[dbo].[ORIENTATIONPROGRAMAUDIT-X] 0
|
||
|
|
[dbo].[ORIENTATIONPROGRAMEMPLOYEE-X] 0
|
||
|
|
[dbo].[ORIENTATIONPROGRAMSETUPFPR-X] 0
|
||
|
|
[dbo].[ORIENTATIONPROGRAMSETUP-X] 0
|
||
|
|
[dbo].[ORIENTATIONPROGRAM-X] 0
|
||
|
|
[dbo].[ORIENTATIONSETUP-X] 0
|
||
|
|
[dbo].[OTPREAPPROVAL] 0
|
||
|
|
[dbo].[PANISHMENT] 1
|
||
|
|
[dbo].[PasswordPolicy] 1
|
||
|
|
[dbo].[PAYROLLTYPECHANGEHISTRY] 0
|
||
|
|
[dbo].[PFPARAMETERHISTORY-X] 0
|
||
|
|
[dbo].[PFRevenueDetail-X] 0
|
||
|
|
[dbo].[PFRevenueMaster-X] 0
|
||
|
|
[dbo].[PFYEARLYPROCESS] 0
|
||
|
|
[dbo].[PMSCOMMENTS] 0
|
||
|
|
[dbo].[PMSSECTIONE] 0
|
||
|
|
[dbo].[POLICYSTATUS-X] 0
|
||
|
|
[dbo].[POLICY-X] 0
|
||
|
|
[dbo].[PRBCalculation-X] 0
|
||
|
|
[dbo].[PRBCostCenter-X] 2
|
||
|
|
[dbo].[PRBEmployeePercent-X] 0
|
||
|
|
[dbo].[PRBKpi-X] 0
|
||
|
|
[dbo].[PRBParameterGrade-X] 17
|
||
|
|
[dbo].[PRBParameter-X] 2
|
||
|
|
[dbo].[PRBProcessDetail-X] 0
|
||
|
|
[dbo].[PRBProcess-X] 0
|
||
|
|
[dbo].[PREMIUM] 0
|
||
|
|
[dbo].[PREMIUMMODE] 0
|
||
|
|
[dbo].[PREVIOUSSALARYMONTHLY] 0
|
||
|
|
[dbo].[PREVIOUSSALARYMONTHLYDETAIL] 0
|
||
|
|
[dbo].[PREVIOUSSALARYPROCESS] 0
|
||
|
|
[dbo].[PURCHASEGROUP] 0
|
||
|
|
[dbo].[PURCHASEGROUPEMPLOYEE] 0
|
||
|
|
[dbo].[PURCHASEREQUISITION] 0
|
||
|
|
[dbo].[RAHIERARCHYMASTER] 1
|
||
|
|
[dbo].[RDLRCOMPONENT] 0
|
||
|
|
[dbo].[RDLREPORTCOMPONENT] 1874
|
||
|
|
[dbo].[RecJobTracking-X] 23
|
||
|
|
[dbo].[RECOGNITIONDETAILS-X] 0
|
||
|
|
[dbo].[RECOGNITIONS-X] 0
|
||
|
|
[dbo].[RECRUIT] 0
|
||
|
|
[dbo].[REGISTRATIONPURPOSE] 0
|
||
|
|
[dbo].[REMINDERCONSTANT] 0
|
||
|
|
[dbo].[REMINDERPROCESSINGSTATUS] 0
|
||
|
|
[dbo].[RemoteUsers-X] 2
|
||
|
|
[dbo].[REPORTGROUPTABLE] 38
|
||
|
|
[dbo].[REQUISITIONCOMMENT] 0
|
||
|
|
[dbo].[REQUISITIONITEM] 0
|
||
|
|
[dbo].[REQUISITIONSTATUS] 0
|
||
|
|
[dbo].[RESULTTYPETEMP-X] 0
|
||
|
|
[dbo].[REWARDSTATEMENTPARAMETER-X] 0
|
||
|
|
[dbo].[REWARDSTATEMENT-X] 0
|
||
|
|
[dbo].[SALARYBATCHPROCESS] 2
|
||
|
|
[dbo].[SALARYGROUPHEAD] 0
|
||
|
|
[dbo].[SALARYGROUPHEADITEM] 0
|
||
|
|
[dbo].[SALARYTEMPDETAIL] 0
|
||
|
|
[dbo].[SalFASHead] 0
|
||
|
|
[dbo].[SBU-X] 0
|
||
|
|
[dbo].[SECTIONC-X] 10
|
||
|
|
[dbo].[SHIFTAPPROVER] 0
|
||
|
|
[dbo].[ShiftDefination] 0
|
||
|
|
[dbo].[SHIFTDEPARTMENT] 0
|
||
|
|
[dbo].[SKILLCATEGORY] 0
|
||
|
|
[dbo].[SKILLMAPPING] 0
|
||
|
|
[dbo].[SKUBATCHSTOCK-X] 0
|
||
|
|
[dbo].[SKUBATCH-X] 0
|
||
|
|
[dbo].[SKUCATEGORY-X] 0
|
||
|
|
[dbo].[SKUSTOCKSERIAL-X] 0
|
||
|
|
[dbo].[SKUSTOCK-X] 0
|
||
|
|
[dbo].[SKU-X] 0
|
||
|
|
[dbo].[STOCKADJUSTMENTTYPE-X] 0
|
||
|
|
[dbo].[STOCKTYPE-X] 0
|
||
|
|
[dbo].[STOCK-X] 0
|
||
|
|
[dbo].[STOREBIN-X] 0
|
||
|
|
[dbo].[STOREEMPLOYEE-X] 0
|
||
|
|
[dbo].[STOREREQUISITIONITEM-X] 0
|
||
|
|
[dbo].[STOREREQUISITION-X] 0
|
||
|
|
[dbo].[STORE-X] 1
|
||
|
|
[dbo].[SYSTEMSETUP] 0
|
||
|
|
[dbo].[TABLEDEPENDENCY] 0
|
||
|
|
[dbo].[TAKANOTES-X] 0
|
||
|
|
[dbo].[taxbak2023-X] 17038
|
||
|
|
[dbo].[TaxJun -X] 158
|
||
|
|
[dbo].[TAXPARAMETERTEMP] 0
|
||
|
|
[dbo].[taxtemp99-X] 16275
|
||
|
|
[dbo].[TEMP_EMPLOYEE-X] 0
|
||
|
|
[dbo].[TempBank1-X] 367
|
||
|
|
[dbo].[TempBasic1-X] 367
|
||
|
|
[dbo].[TEMPORDINARYHOURTEST-X] 0
|
||
|
|
[dbo].[TEMPORDINARYHOUR-X] 0
|
||
|
|
[dbo].[TEMPOTHOURTEST-X] 0
|
||
|
|
[dbo].[TEMPOTHOUR-X] 0
|
||
|
|
[dbo].[TERMENTITY] 0
|
||
|
|
[dbo].[TMPOT-X] 0
|
||
|
|
[dbo].[Tour] 0
|
||
|
|
[dbo].[TRAININGEXPENDITURE] 1
|
||
|
|
[dbo].[TRAININGEXPENDITUREHEAD] 1
|
||
|
|
[dbo].[TRAININGFORDEPARTMENT] 0
|
||
|
|
[dbo].[TRAININGFORFUNCTION] 2
|
||
|
|
[dbo].[TRAININGFORGRADE] 3
|
||
|
|
[dbo].[TRAININGNEEDED] 0
|
||
|
|
[dbo].[TRAININGQUALIFICATION] 0
|
||
|
|
[dbo].[TRAININGREQUISITION] 1
|
||
|
|
[dbo].[TRAININGSCHEDULEFORDEPARTMENT] 2
|
||
|
|
[dbo].[TRAININGSCHEDULEFORFUNCTION] 4
|
||
|
|
[dbo].[TRAININGSCHEDULEFORGRADE] 6
|
||
|
|
[dbo].[TRANSFEROFCRG] 0
|
||
|
|
[dbo].[TRANSFERTPTOPR] 0
|
||
|
|
[dbo].[userfullactivity] 10
|
||
|
|
[dbo].[userfullactivity_22342BEDE8BB4B3DA62D7D881FF6B6E7] 0
|
||
|
|
[dbo].[userfullactivity_34B148F642444A3C979ECD752FA818CE] 0
|
||
|
|
[dbo].[userfullactivity_4F9B7ACE957445FD86B9F715AD95F4CC] 0
|
||
|
|
[dbo].[userfullactivity_5EEC39DC6FC1436A8C6EEA7CFEE4B2B0] 0
|
||
|
|
[dbo].[userfullactivity_B372D981770047F7BF7A7639742953E2] 0
|
||
|
|
[dbo].[USERGROUP] 12
|
||
|
|
[dbo].[userlocation-X] 0
|
||
|
|
[dbo].[USERPERMISSION] 631
|
||
|
|
[dbo].[VW_EMPLOYEEIMPORTANTINFOWITHSALARYNEW-x] 0
|
||
|
|
[dbo].[WEBMENU] 92
|
||
|
|
[dbo].[WEBMENUROLE] 102
|
||
|
|
[dbo].[WEEKCALENDAR] 0
|
||
|
|
[dbo].[WFRULENODE] 0
|
||
|
|
[dbo].[-X] 0
|
||
|
|
[dbo].[YEARLYACHIEVEMENT] 0
|
||
|
|
[dbo].[Z_BADLOGINATTEMPTINFO] 0
|
||
|
|
[dbo].[Z_USERLOGININFO] 0
|
||
|
|
222
|
||
|
|
|
||
|
|
=== B. Used only by DB stored procedures/views/functions (17) ===
|
||
|
|
Table
|
||
|
|
|
||
|
|
Rows Referenced by
|
||
|
|
[dbo].[ConfirmationProcess] 25 SP_PendingJobs
|
||
|
|
[dbo].[CONFIRMATIONREMINDER] 998 SP_ConfirmationReminder, SP_ConfirmationUntouched
|
||
|
|
[dbo].[CRM_ADDRESSES] 7 InsertAddress, UpdateAddress
|
||
|
|
[dbo].[CRM_AdjustmentType] 5 InsertCRM_AdjustmentType, UpdateCRM_AdjustmentType
|
||
|
|
[dbo].[CRM_BUSINESSPARTNER] 3 GetLastPORate, InsertBusinessPartner, UpdateBusinessPartner
|
||
|
|
[dbo].[CRM_Currencies] 3 GetLastPORate
|
||
|
|
[dbo].[CRM_EContacts] 7 InsertEContact, UpdateEcontact
|
||
|
|
[dbo].[CRM_POItem] 64 GetLastPORate
|
||
|
|
[dbo].[CRM_ProductCategories] 55 InsertProductCategories, UpdateProductCategories
|
||
|
|
[dbo].[CRM_PurchaseOrder] 41 GetLastPORate
|
||
|
|
[dbo].[CRM_SKUs] 2 InsertSKU
|
||
|
|
[dbo].[CRM_StoreInventoryTypes] 60 InsertStoreInventoryTypes
|
||
|
|
[dbo].[CRM_Stores] 8 InsertStore, UpdateStore
|
||
|
|
[dbo].[CRM_ThisSystem] 1 InsertThisSystem, UpdateThisSystem
|
||
|
|
[dbo].[RAHIERARCHYNODE] 1733 SP_ConfirmationReminder, vw_empLineManager
|
||
|
|
[dbo].[RANODEPROPERTY] 1733 SP_ConfirmationReminder, SP_ConfirmationUntouched, tr_statusChanged, vw_empLineManager
|
||
|
|
[dbo].[RDLREPORT] 81 tr_rdl
|
||
|
|
|
||
|
|
=== C. Name appears in SQL outside HRM.DA/DA (some may be ordinary words) (26) ===
|
||
|
|
Table Rows
|
||
|
|
0
|
||
|
|
[dbo].[CALENDAR] 0
|
||
|
|
[dbo].[CardInfo] 0
|
||
|
|
[dbo].[CREWDEPLOYMENT] 0
|
||
|
|
[dbo].[CVMAIN] 0
|
||
|
|
[dbo].[DashboardInformation] 1
|
||
|
|
[dbo].[DELETED_LEAVEENTRY] 0
|
||
|
|
[dbo].[DELETED_WFMOVEMENTNEXT] 0
|
||
|
|
[dbo].[DELETED_WFMOVEMENTTASK] 0
|
||
|
|
[dbo].[DELETED_WFMOVEMENTTRAN] 0
|
||
|
|
[dbo].[DETAILS] 0
|
||
|
|
[dbo].[EMPLOYEEMONTHLYEXPENSE] 0
|
||
|
|
[dbo].[FACTORYDESIGNATION] 0
|
||
|
|
[dbo].[FSHEADS] 0
|
||
|
|
[dbo].[LEAVEREASON] 0
|
||
|
|
[dbo].[MARKETSURVEY] 0
|
||
|
|
[dbo].[PERMISSION] 0
|
||
|
|
[dbo].[PFMEMBERSHIP] 0
|
||
|
|
[dbo].[REPORT] 0
|
||
|
|
[dbo].[TRAINEE] 1
|
||
|
|
[dbo].[WFRULESTEP] 13
|
||
|
|
[dbo].[WORKFLOWTYPE] 0
|
||
|
|
[dbo].[WorkPlan] 0
|