COMPANYPrompt Table: COMPANY_VW
DECL_YR_2483_FRACERFA_NUM_FRAGROUP_2483_ID_FRAINDICATOR_2483_FRAEDIT_2483_FRA(SQL Table) |
Index Back |
|---|---|
Edit 2483 Table"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 used to track the values of the various indicators." |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_VW |
| 2 | DECL_YR_2483_FRA |
Number(4,0) | SMALLINT NOT NULL | French Report 2483 : Declaring Year |
| 3 | CERFA_NUM_FRA |
Character(10) | VARCHAR2(10) NOT NULL | Cerfa Number 2483 |
| 4 | GROUP_2483_ID_FRA |
Character(2) | VARCHAR2(2) NOT NULL | 2483 Group |
| 5 | INDICATOR_2483_FRA |
Character(5) | VARCHAR2(5) NOT NULL | 2483 Indicator |
| 6 | CREATION_DT | Date(10) | DATE | Creation Date |
| 7 | VALUE1_2483_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Value 1 |
| 8 | VALUE2_2483_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Value 2 |
| 9 | VALUE3_2483_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Value 3 |
| 10 | VALUE4_2483_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Value 4 |
| 11 | VALUE5_2483_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Value 5 |
| 12 | VALUE6_2483_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Value 6 |
| 13 | VALUEC_2483_FRA | Character(50) | VARCHAR2(50) NOT NULL | String value for 2483 result table |