EDIT_2483FRA_VW (SQL View)	Index Back
Edit 2483 View "2483 is the name of a french mandatory report for Budget Training. A lot of training indicators or ratios dealing with training budgets, number of trainees are calculated and classified into several categories called groups. This record is a view on the table used to track the values of the various indicators."

EDIT_2483FRA_VW

(SQL View)

Edit 2483 View

"2483 is the name of a french mandatory report for Budget Training. A lot of training indicators or ratios dealing with training budgets, number of trainees are calculated and classified into several categories called groups. This record is a view on the table used to track the values of the various indicators."

SELECT DISTINCT CERFA_NUM_FRA ,COMPANY , DECL_YR_2483_FRA , GROUP_2483_ID_FRA , CREATION_DT FROM PS_EDIT_2483_FRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CERFA_NUM_FRA Character(10) VARCHAR2(10) NOT NULL Cerfa Number 2483

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_VW

3 DECL_YR_2483_FRA Number(4,0) SMALLINT NOT NULL French Report 2483 : Declaring Year

4 GROUP_2483_ID_FRA Character(2) VARCHAR2(2) NOT NULL 2483 Group

5 CREATION_DT Date(10) DATE Creation Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CERFA_NUM_FRA	Character(10)	VARCHAR2(10) NOT NULL	Cerfa Number 2483
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_VW
3	DECL_YR_2483_FRA	Number(4,0)	SMALLINT NOT NULL	French Report 2483 : Declaring Year
4	GROUP_2483_ID_FRA	Character(2)	VARCHAR2(2) NOT NULL	2483 Group
5	CREATION_DT	Date(10)	DATE	Creation Date