SAD_UC_HESA_STGSAD_UC_HESA_FLDPrompt Table: SAD_UC_HEFLD_VW
Y/N Table Edit
E=Entry Profile
P=Person
1=Add/Update
2=Add if Blank
SAD_UC_HESG_REC(SQL Table) |
Index Back |
|---|---|
UCAS HESA staging field record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_UC_HESA_STG |
Character(50) | VARCHAR2(50) NOT NULL | Staging Field |
| 2 | SAD_UC_HESA_FLD |
Character(50) | VARCHAR2(50) NOT NULL |
HESA Field
Prompt Table: SAD_UC_HEFLD_VW |
| 3 | DESCR200 | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
| 4 | SAD_UC_HESA_IMP | Character(1) | VARCHAR2(1) NOT NULL |
Import
Y/N Table Edit |
| 5 | SAD_UC_HESA_RECD | Character(1) | VARCHAR2(1) NOT NULL |
HESA Record
E=Entry Profile P=Person |
| 6 | SAD_UC_UPD_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Update Option
1=Add/Update 2=Add if Blank |