Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
PROFILE_IDPrompt Table: PROFILE_TBL
N=Non Cap
Y=Capitalize
PROFILETBL_NKVW(SQL View) |
Index Back |
|---|---|
Asset Profile Prompt (non-key)Used by Asset Search |
| SELECT SETID , PROFILE_ID , DESCR , FINANCIAL_ASSET_SW , ASSET_CLASS FROM PS_PROFILE_TBL |
| # | 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 | PROFILE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table: PROFILE_TBL |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | FINANCIAL_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap Y=Capitalize |
| 5 | ASSET_CLASS | Character(10) | VARCHAR2(10) NOT NULL | Asset Class |