SETIDDefault Value: ADB_FLDS_TBL.SETID
Prompt Table: SP_SETID_NONVW
ADBDefault Value: ADB_FLDS_TBL.ADB
FIELD_SEQUENCEDefault Value: ADB_FLDS_TBL.FIELD_SEQUENCE
SELECT_VALUEPrompt Table: %EDITTABLE
Prompt Table: %EDITTABLE
ADB_FLDV_TBL(SQL Table) |
Index Back |
|---|---|
ADB ChartFields Value |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: ADB_FLDS_TBL.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ADB |
Character(10) | VARCHAR2(10) NOT NULL |
Average Daily Balances
Default Value: ADB_FLDS_TBL.ADB |
| 3 | FIELD_SEQUENCE |
Number(3,0) | SMALLINT NOT NULL |
Field Sequence Number
Default Value: ADB_FLDS_TBL.FIELD_SEQUENCE |
| 4 | SELECT_VALUE |
Character(30) | VARCHAR2(30) NOT NULL |
Select Value
Prompt Table: %EDITTABLE |
| 5 | TO_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
To Value
Prompt Table: %EDITTABLE |