EM_MG_CF_DUPVW (SQL View)	Index Back
View to find CF Identifier View to find CF Identifier

EM_MG_CF_DUPVW

(SQL View)

View to find CF Identifier

SELECT a.account , a.altacct , a.deptid , %subrec(cf18a_ak_sbr, a) , %subrec(pc_cfar_n_sbr, a) , a.speedchart_key , a.account_code , a.em_mg_cf_combo FROM PS_EM_MG_CF_COMBO a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

2 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

4 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

5 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

6 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

7 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

8 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

9 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

10 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

11 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

12 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

13 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

14 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

15 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

16 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

17 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

18 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

19 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

20 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

21 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

22 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: PC_GL_AN_GRP_VW
Set Control Field: BUSINESS_UNIT_PC

23 SPEEDCHART_KEY Character(10) VARCHAR2(10) NOT NULL SpeedChart Key

24 ACCOUNT_CODE Character(20) VARCHAR2(20) NOT NULL Accounting Tag

25 EM_MG_CF_COMBO Number(9,0) DECIMAL(9) NOT NULL Chartfield Combination ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
2	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
3	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
4	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
5	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
6	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
7	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
8	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
9	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
10	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
11	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
12	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
13	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
14	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
15	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
16	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
17	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
18	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
19	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
20	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
21	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
22	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: PC_GL_AN_GRP_VW Set Control Field: BUSINESS_UNIT_PC
23	SPEEDCHART_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedChart Key
24	ACCOUNT_CODE	Character(20)	VARCHAR2(20) NOT NULL	Accounting Tag
25	EM_MG_CF_COMBO	Number(9,0)	DECIMAL(9) NOT NULL	Chartfield Combination ID