SETIDPrompt Table: SP_SETID_NONVW
APPLICATIONA=Active
I=Inactive
Default Value: A
Prompt Table: PGM_APPLAREA_AC
Prompt Table: IT_SFTWR
PGM_APPLICATION(SQL Table) |
Index Back |
|---|---|
ApplicationApplication usually refers to software application. An application must belong to an Application Area. The values on this table are user defined. Examples of usage may include "Payables", "Projects", "Purchasing", etc. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | APPLICATION |
Character(10) | VARCHAR2(10) NOT NULL | Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area. |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | APPLICATION_AREA | Character(10) | VARCHAR2(10) NOT NULL |
The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
Prompt Table: PGM_APPLAREA_AC |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | SFTWR_TITLE | Character(50) | VARCHAR2(50) NOT NULL |
Software Title
Prompt Table: IT_SFTWR |