PA_FUNCTN(SQL Table) |
Index Back |
|---|---|
FunctionsThis is a setup table containing the names of the Functions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | Function Name | |
| 2 | FUNCTN_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Function Sequence Number |
| 3 | EXPOSE_INT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Panel Exposed/Internal Func
E=Exposed I=Internal |
| 4 | FLD_CNT | Number(3,0) | SMALLINT NOT NULL | Field Count |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | PROC_INSTALL_CD | Character(1) | VARCHAR2(1) NOT NULL |
Process Installed Code
E=Excluded I=Installed |
| 7 | PROC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Process Type
C=Custom Statement R=Function Result U=User Code |
| 8 | PROC_PREV_ELIG_CD | Character(1) | VARCHAR2(1) NOT NULL | Process Previously Eligible Co |