UPG_2483_AET(SQL Table) |
Index Back |
|---|---|
Budget Training Cache RecordThis cache record is used for Budget Training Process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | VENDOR | Character(6) | VARCHAR2(6) NOT NULL | Vendor ID |
| 5 | TRN_VENDOR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Type
C=Consulting Firm E=Equipment Rental F=Facilities Rentals I=Outside Instructors M=Training Materials O=Other P=Training Provider S=Guest Speaker T=Financing Fund |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 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 |
| 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 |
| 25 | FONGECIF_CD_FRA | Character(6) | VARCHAR2(6) NOT NULL | FONGECIF Code |
| 26 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 27 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
| 28 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 29 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 30 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 31 | DECL_YR_2483_FRA | Number(4,0) | SMALLINT NOT NULL | French Report 2483 : Declaring Year |
| 32 | EFFDT | Date(10) | DATE | Effective Date |
| 33 | YEAR | Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 34 | FGH_GRP_REDUC_PCT | Number(5,2) | DECIMAL(4,2) NOT NULL | Reduction Rate (10 Emp. Mark) |
| 35 | C8_2483_AMOUNT | Number(19,3) | DECIMAL(18,3) NOT NULL | Indicator 8 |
| 36 | C12_2483_AMOUNT | Number(19,3) | DECIMAL(18,3) NOT NULL | Indicator 12 |
| 37 | F_GRP_CONT_PCT | Number(4,2) | DECIMAL(3,2) NOT NULL | Reduction Rate |
| 38 | F01_2483_AMOUNT | Number(19,3) | DECIMAL(18,3) NOT NULL | Indicator 1 |
| 39 | G_GRP_CONT_PCT | Number(4,2) | DECIMAL(3,2) NOT NULL | Reduction Rate |
| 40 | G11_2483_AMOUNT | Number(19,3) | DECIMAL(18,3) NOT NULL | Indicator 11 |
| 41 | H_GRP_CONT_PCT | Number(4,2) | DECIMAL(3,2) NOT NULL | Reduction Rate |
| 42 | J20_2483_AMOUNT | Number(19,3) | DECIMAL(18,3) NOT NULL | Indicator 20 |
| 43 | J22_2483_AMOUNT | Number(19,3) | DECIMAL(18,3) NOT NULL | Indicator 22 |
| 44 | K25_2483_AMOUNT | Number(19,3) | DECIMAL(18,3) NOT NULL | Indicator 25 |
| 45 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |