POSITION_CONFIG(SQL Table) |
Index Back |
|---|---|
Configuration RecordPosition Managment Flag |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  POSITION_FL_FLG |
Character(1) | VARCHAR2(1) NOT NULL |
Fluid Position Management Flag
N=No Y=Yes Y/N Table Edit |
| 2 | POSN_PRI_INUMB_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Fluid Position Management Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 3 | POSN_PKG_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Application pakage name
N=No Y=Yes |
| 4 | POSN_PKGROOT | Character(30) | VARCHAR2(30) NOT NULL |
Package Root
Prompt Table: POSN_PKG_VW |
| 5 | POSN_QUALPATH | Character(127) | VARCHAR2(127) NOT NULL |
Application pakage Path
Prompt Table: POSN_PATH_VW |
| 6 | POSN_CLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Class ID for Application pakage
Prompt Table: POSN_CLASS_VW |
| 7 | POSN_METHOD | Character(60) | VARCHAR2(60) NOT NULL | Application pakage Method Name |
| 8 | POS_APPR_NEW | Character(1) | VARCHAR2(1) NOT NULL |
AWE flag for job data setup
Y/N Table Edit Default Value: N |
| 9 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: EOAW_TXN |
| 10 | POS_APPR_MANAGE | Character(1) | VARCHAR2(1) NOT NULL |
AWE flag for position data setup
Y/N Table Edit |
| 11 | POS_EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: EOAW_TXN |
| 12 | POS_MSS_ATTACH | Character(1) | VARCHAR2(1) NOT NULL |
Gender Identity Flag
N=No Y=Yes |
| 13 | POSITION_MSS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Fluid Position Management MSS Flag
N=No Y=yES |
| 14 | POSITION_MULT_TRN | Character(1) | VARCHAR2(1) NOT NULL | Gender Identity Flag |
| 15 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL |
Action Items - Action Item List ID
Prompt Table: POS_PTAI_VW |
| 16 | POS_MSS_EOAWPRCS | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: EOAW_TXN |