BCT_MG_ACT_VW (SQL View)	Index Back
Barcode Act Hrs Search Record 08/28/01 MEG CN#MG840: Since Message Agent is gone put in prompt table edits.

BCT_MG_ACT_VW

(SQL View)

Barcode Act Hrs Search Record

08/28/01 MEG CN#MG840: Since Message Agent is gone put in prompt table edits.

SELECT A.BUSINESS_UNIT , X.FIELDVALUE , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_BUS_UNIT_TBL_IN A , PSXLATITEM X WHERE A.BU_STATUS = '1' AND X.FIELDNAME = 'TRANSACTION_CODE' AND X.fieldvalue BETWEEN '0241' AND '0242' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND X.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMG_NONVW

2 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
Prompt Table: BCT_T_MG_ACT_VW

3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMG_NONVW
2	TRANSACTION_CODE	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code Prompt Table: BCT_T_MG_ACT_VW
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
4	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name