UPG_RET_DFLTS(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | BENEFIT_SYSTEM | Character(2) | VARCHAR2(2) NOT NULL | 
A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits.
 BA=Benefits Administration BN=Base Benefits OT=Not Managed in PeopleSoft  | 
| 2 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | 
Earnings Code
 Prompt Table: EARNINGS_TBL  |