HCHB_PAYOR_SOURCES

312 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ps_id int 4 null
ps_ptid int 4 null
ps_active char 1 null
ps_required char 1 null
ps_insertdate datetime 16,3 null
ps_lastupdate datetime 16,3 null
ps_desc varchar 50 null
ps_address varchar 81 null
ps_city varchar 50 null
ps_state char 2 √ null
ps_zip varchar 10 null
ps_phone varchar 25 null
ps_frequentlyused char 1 null
ps_physicianmedicaid char 1 null
ps_sbid int 4 √ null
ps_itid int 4 √ null
ps_agencycontact varchar 50 √ null
ps_freq int 4 null
ps_fsgl varchar 6 √ null
ps_485required char 1 √ null
ps_oasisrequired char 1 √ null
ps_lengthofepisode int 4 √ null
ps_arglid int 4 √ null
ps_sltid int 4 null
ps_hospicelengthofepisode1 int 4 null
ps_hospicelengthofepisode2 int 4 null
ps_hospicelengthofepisode3 int 4 null
ps_rbbillingcode varchar 10 √ null
ps_hrtid int 4 √ null
ps_externalid varchar 25 √ null
ps_excludeverworkflow char 1 √ null
ps_bapid int 4 √ null
ps_billbymonth bit 1 null
ps_spanacrossepisodes bit 1 null
ps_reauththreshholddays int 4 null
ps_reauththreshholdvisits int 4 null
ps_numofdayspendingauthlasts int 4 null
ps_contractualadjustmentsbyclient char 1 √ null
ps_createorderdrivenauths char 1 √ null
ps_addressline2 varchar 80 √ null
ps_excludeinsverifyworkflowonrecerts char 1 √ null
ps_excludefrommonthlyreverifyworkflow char 1 √ null
ps_default_cpid int 4 √ null
ps_generateauthworkflow char 1 √ null
ps_fax varchar 25 √ null
ps_showpatientcaretime char 1 √ null
ps_splitbyauthno bit 1 null
ps_excludeobtainadditionalauthworkflow char 1 √ null
ps_printnameandidonmedicalrecords bit 1 null
ps_electroniceligibility int 4 null
ps_IncludeInCarePlanCert char 1 null
ps_autoclearheldclaims char 1 null
ps_UseTherapyAssessment char 1 √ null
ps_TherapyAssessmentDate datetime 16,3 √ null
ps_enableF2FEncounterFeature char 1 √ null
ps_CoverSheetID int 4 √ null
ps_allowConcurrentBilling bit 1 null
ps_bypassperformclaimsaudit char 1 null
ps_useadditionalclaimcodes char 1 null
ps_allowReplacementClaims bit 1 null
ps_billByDay bit 1 null
ps_billByDiscipline bit 1 null
ps_allowvaluecodes bit 1 null
ps_noncoveredcharges bit 1 null
ps_ExcludeObtainInitialAuthWorkflow char 1 null
ps_IncludeDateOfDeathInBilling bit 1 null
ps_IncludeDischargeDateInBilling bit 1 null
ps_billByBranch bit 1 null
ps_ppscategory int 4 √ null
ps_CLIABilling bit 1 null
ps_billPhysicianServices bit 1 null
ps_combinePhysicianServiceAndLocClaims bit 1 null
ps_combineRoomAndBoardAndLocClaims bit 1 null
ps_rbBillingCode2 varchar 6 √ null
ps_FileSplit int 4 null
ps_rptid int 4 null
ps_enableVerifySpendDownMet bit 1 null
ps_spenddowndayofmonth int 4 √ null
ps_sendDOBin270 bit 1 null
ps_useCustomRates bit 1 null
ps_bypassRAPBilling bit 1 null
ps_forceHIPPSToEarlyTiming bit 1 null
ps_forceHIPPSToNoSupplies bit 1 null
ps_medicationChargesOnClaim bit 1 null
ps_refreshPendingAuth bit 1 null
ps_nonCoveredAdjustmentCodeID int 4 √ null
ps_enablePECOSVerification bit 1 null
ps_PECOSVerificationStartDate date 6 √ null
ps_noerequired bit 1 null
ps_noesubmissionlimit int 4 null
ps_donotcreateadjustnoe bit 1 null
ps_noesubmissionlimitenabled bit 1 null
ps_TherapyAssessmentEndDate datetime 16,3 √ null
ps_UseTherapyAssessment2015 bit 1 null
ps_TherapyAssessment2015StartDate datetime 16,3 √ null
ps_TherapyAssessment2015EndDate datetime 16,3 √ null
ps_F2FEncounterEffectiveDate date 6 √ null
ps_excludedischargedateForLOC bit 1 null
ps_excludedischargedateforLOCadjustmentcodeID int 4 √ null
ps_excludedateofdeathforLOC bit 1 null
ps_excludedateofdeathforLOCadjustmentcodeID int 4 √ null
ps_SplitClaimByLOCValueCode bit 1 null
ps_splitInvoiceForRoomAndBoardAncillaryCharge bit 1 null
ps_generateConcurrentWorkflow bit 1 null
ps_ICD9NotRequiredDate date 6 √ null
ps_enablerecertwindow bit 1 null
ps_hrrate_siaenabled bit 1 null
ps_hrrate_siafromdate date 6 √ null
ps_hrrate_tierlocenabled bit 1 null
ps_hrrate_tierlocfromdate date 6 √ null
ps_PPSPreClaimReviewParticipant bit 1 null
ps_EnableElectronicAuth bit 1 null
ps_enable_billingaudit_holddays bit 1 null
ps_billingaudit_holddays int 4 √ null
ps_enable_AddedServices bit 1 null
ps_enable_fifthLevelOfCare bit 1 null
ps_splitInvoiceForSiaCharges bit 1 null
ps_allowSendingOfNonMedicareOasis bit 1 null
ps_useRnLpnHcpcsEffectiveDate datetime2 16,7 √ null
ps_enableDisposableNPWTBilling bit 1 null
ps_disposableNpwtPartB bit 1 null
ps_ReviewEligibilityResponse bit 1 null
ps_ReviewOnDemandEligibilityResponse bit 1 null
ps_ReverifyBenefits bit 1 null
ps_ReverifyMethod varchar 50 √ null
ps_DayToReVerify1 int 4 null
ps_DayToReVerify2 int 4 √ null
ps_DaysSinceLastEligibilityCheck int 4 null
ps_ICD10DisplayedOnlyDate date 6 √ null
ps_noEligibilityResponseReturned bit 1 null
ps_enablePhysicianStateParticipationVerification bit 1 null
ps_PhysicianStateParticipationVerificationStartDate date 6 √ null
ps_PhysicianStateParticipationVerificationCredentialType int 4 √ null
ps_enableCaseRateBilling bit 1 null
ps_recertdurationwithcert bit 1 null
ps_splitByBillingLevel bit 1 null
ps_SuppressVisitUtilizationInPointCare bit 1 null
ps_Generate60DayReadmissionWorkflow bit 1 null
ps_IsMedicareReplacementPayor bit 1 null
AVA_insert_date datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_HCHB_PAYOR_SOURCES Primary key Asc ps_id

Diagram producer might be missing

No diagrams were produced please see application output for any errors