BN_834_COMP_LNG (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_LNG

(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.LANGUAGE_CD , A.DESCR FROM PS_COMPNY_TBL_LANG 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)

Related Language Record for BN_834_COMP_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description