BCT_INPUT_VW (SQL View)	Index Back
Primary record for BCT input This record is used to pass the key fields from teh search view to the component in the BCT input pages.

BCT_INPUT_VW

(SQL View)

Primary record for BCT input

This record is used to pass the key fields from teh search view to the component in the BCT input pages.

SELECT A.BUSINESS_UNIT , B.FIELDVALUE FROM PS_BUS_UNIT_TBL_IN A , PSXLATITEM B WHERE A.BU_STATUS = '1' AND B.FIELDNAME = 'TRANSACTION_CODE' AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

2 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
2	TRANSACTION_CODE	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code