WCS_ECM_ACS_VW

(SQL View)

SELECT CFG.BUDGET_ID , CFG.BUDGET_START_DT , CFG.TREE_NAME , GRP.EMPLID , GRP.EMPL_RCD , NM.NAME_DISPLAY ,%Sql(HCSC_COMPOSITE_ID, GRP.EMPLID, GRP.EMPL_RCD) FROM PS_WCS_ECM_CYC_CFG CFG , PS_GB_GRP_RES_TBL GRP , PS_PERSONAL_DATA NM WHERE CFG.GB_GROUP_ID = GRP.GB_GROUP_ID AND GRP.EMPLID = NM.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID

2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date

3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: WCS_ECM_TREEVW1

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

7 EMPL_ID_RCD Character(20) VARCHAR2(20) NOT NULL Job concatenated key.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
2	BUDGET_START_DT	Date(10)	DATE NOT NULL	Budget Start Date
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: WCS_ECM_TREEVW1
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
7	EMPL_ID_RCD	Character(20)	VARCHAR2(20) NOT NULL	Job concatenated key.