SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
USR_DEF_IDRE_UDF(SQL Table) |
Index Back |
|---|---|
User Defined Fields (Setup)This record is used in setup and configuration of 10 User Defined Fields to be used by Lease Administration. The values for these User Defined Fields are set in Lease Maintenance. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | USR_DEF_ID |
Number(10,0) | DECIMAL(10) NOT NULL | This field holds the Unique ID for each User Defined Field in a SetID. |
| 3 | UDF_FLDNM | Character(15) | VARCHAR2(15) NOT NULL | This field holds the label for the User Defined Field. |
| 4 | UDF_DESCR | Character(30) | VARCHAR2(30) NOT NULL | This field holds the description for the User Defined Field. |