BN_834_COMP_VW (SQL View)	Index Back
HIPAA 834 Company Prompt View Used as a prompt table on the HIPAA 834 EDI run control page to limit the companies that can be selected to those represented on the Benefits Enrollment Snapshot tables (as long as they are also on the company table).

BN_834_COMP_VW

(SQL View)

HIPAA 834 Company Prompt View

Used as a prompt table on the HIPAA 834 EDI run control page to limit the companies that can be selected to those represented on the Benefits Enrollment Snapshot tables (as long as they are also on the company table).

SELECT A.COMPANY , A.DESCR , A.FEDERAL_EIN FROM PS_COMPANY_TBL A WHERE A.COMPANY IN ( SELECT DISTINCT B.COMPANY FROM PS_BN_SNAP_JOB B , PS_BN_SNAP_PLAN C WHERE C.EMPLID = B.EMPLID AND C.BENEFIT_RCD_NBR = B.BENEFIT_RCD_NBR AND C.COBRA_EVENT_ID = B.COBRA_EVENT_ID AND C.COVERAGE_ELECT IN ('E','T') AND %Substring(C.PLAN_TYPE, 1, 1) = '1') AND %EffdtCheck(COMPANY_TBL A1, A, %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Federal EIN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	FEDERAL_EIN	Number(9,0)	DECIMAL(9) NOT NULL	Federal EIN