SETIDDefault Value: OPRDEFTBL_UPG.SETID
Prompt Table: SP_SETID_NONVW
FEE_SCHEDULESEQUENCE_NBRDefault Value: 1
SALARY_RANGE_MAXSALARY_RANGE_MINPOTENTIALIN_UPG(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPRDEFTBL_UPG.SETID Prompt Table: SP_SETID_NONVW |
| 2 | FEE_SCHEDULE |
Character(50) | VARCHAR2(50) NOT NULL | Fee Schedule |
| 3 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 4 | SALARY_RANGE_MAX |
Number(11,2) | DECIMAL(10,2) NOT NULL | Maximum Salary Range |
| 5 | SALARY_RANGE_MIN |
Number(11,2) | DECIMAL(10,2) NOT NULL | Salary Range |
| 6 | FEE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Fee Percentage |
| 7 | COMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |