SETIDDefault Value: OPR_DEF_TBL.SETID
Prompt Table: SP_SETID_NONVW
FEE_SCHEDULESEQUENCE_NBRDefault Value: 1
SALARY_RANGE_MAXSALARY_RANGE_MINLANGUAGE_CDFO_POT_INC_LNG(SQL Table) |
Index Back |
|---|---|
Potential Income |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | COMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |