OPRIDRUNCNTLIDGROUP_2483_ID_FRAINDICATOR_2483_FRAA=Annual
M=Multi-Annula
S=Simple
Prompt Table: COUNTRY_TBL
AB=House Boat Reference
WW=House Trailer Reference
Prompt Table: STATE_TBL
Y/N Table Edit
EDIT_2483G_FRA(SQL Table) |
Index Back |
|---|---|
Edit 2483 Group G 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 for Group G." |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUNCNTLID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | GROUP_2483_ID_FRA |
Character(2) | VARCHAR2(2) NOT NULL | 2483 Group |
| 4 | INDICATOR_2483_FRA |
Character(5) | VARCHAR2(5) NOT NULL | 2483 Indicator |
| 5 | AGREEMENT_DT_FRA | Date(10) | DATE | Agreement Date |
| 6 | AGREEMENT_TYPE_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Agreement Type
A=Annual M=Multi-Annula S=Simple |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 9 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 10 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 11 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 12 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 13 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 14 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 15 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 16 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 17 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 18 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 19 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 20 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 21 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 22 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 23 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 24 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 25 | PER_UNIT_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Per Unit Cost |