FPMSYSTEM_TBL(SQL Table) |
Index Back |
|---|---|
FPS Installation Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FP_AUTOSTPTEN | Character(1) | VARCHAR2(1) NOT NULL |
Auto Step Increment at Tenure
Y/N Table Edit Default Value: N |
| 2 | FP_REASN_AUTO | Character(3) | VARCHAR2(3) NOT NULL |
Tenure Step Increment Reason
Prompt Table: FPMACTNREA_VW2 |
| 3 | FP_ACTN_HIR | Character(3) | VARCHAR2(3) NOT NULL |
Action for Hiring
Prompt Table: FPMACTION_VW2 |
| 4 | FP_ACTN_REH | Character(3) | VARCHAR2(3) NOT NULL |
Action for Re-hiring
Prompt Table: FPMACTION_VW2 |
| 5 | FP_ACTN_TEN | Character(3) | VARCHAR2(3) NOT NULL |
Action for Tenure
Prompt Table: FPMACTION_VW2 |
| 6 | FP_ACTN_TIE | Character(3) | VARCHAR2(3) NOT NULL |
With Seniority Carry Over
Prompt Table: FPMACTION_VW2 |
| 7 | FP_ACTN_POSN | Character(3) | VARCHAR2(3) NOT NULL |
Action for Position Data Chnge
Prompt Table: FPMACTION_VW2 |
| 8 | FP_REASN_TEN | Character(3) | VARCHAR2(3) NOT NULL |
Tenure Reason
Prompt Table: FPMACTNREA_VW1 |
| 9 | FP_ACTN_STEP | Character(3) | VARCHAR2(3) NOT NULL |
Action for (Sub)Step Increment
Prompt Table: FPMACTION_VW2 |
| 10 | FP_REASN_STEP | Character(3) | VARCHAR2(3) NOT NULL |
(Sub)Step Incrmnt Reason
Prompt Table: FPMACTNREA_VW2 |
| 11 | FP_ACTN_RANK | Character(3) | VARCHAR2(3) NOT NULL |
Action for Grade Promotion
Prompt Table: FPMACTION_VW2 |
| 12 | FP_AUTO_RATFY | Character(1) | VARCHAR2(1) NOT NULL |
Auto Hire Validation
Y/N Table Edit Default Value: N |
| 13 | FP_SENCARE_ITM | Character(6) | VARCHAR2(6) NOT NULL |
Career Seniority Heading Nb
Prompt Table: FPMBON_ITM_TBL |
| 14 | FP_SENNAS_ITM | Character(6) | VARCHAR2(6) NOT NULL |
Military Service Sen Hding Nb
Prompt Table: FPMBON_ITM_TBL |
| 15 | FP_SENEXP_ITM | Character(6) | VARCHAR2(6) NOT NULL |
Work Exp Sen Heading Nb
Prompt Table: FPMBON_ITM_TBL |
| 16 | FP_SENSKL_ITM | Character(6) | VARCHAR2(6) NOT NULL |
Competence Sen Heading Nb
Prompt Table: FPMBON_ITM_TBL |
| 17 | FP_CALDURPSN | Character(1) | VARCHAR2(1) NOT NULL |
Length Calculation
C=Calendar T=Thirtieth Default Value: C |
| 18 | FP_REQ_NBR | Number(8,0) | INTEGER NOT NULL | Last Request Number |
| 19 | FP_COLDECINCR | Number(8,0) | INTEGER NOT NULL | Last Order Number |
| 20 | FP_REFCOL_PS | Number(8,0) | INTEGER NOT NULL | PSoft Ref Collective Order |
| 21 | HOURLY_RT_FRA | Character(3) | VARCHAR2(3) NOT NULL |
HFR
Prompt Table: HOURS_TYPE_FRA |
| 22 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Default Value: M |
| 23 | FP_CTRL_STCUT | Character(1) | VARCHAR2(1) NOT NULL |
Control Reduc Step Length
Y/N Table Edit Default Value: N |
| 24 | FP_TENTERM_DY | Number(2,0) | SMALLINT NOT NULL |
Days Before Tenure
Default Value: 30 |
| 25 | FP_PROMTERM_DY | Number(2,0) | SMALLINT NOT NULL |
Days Before (Sub)Step Incremnt
Default Value: 30 |
| 26 | FP_RETMNT_AGE | Number(2,0) | SMALLINT NOT NULL | Retirement Age |
| 27 | FP_TERMDT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Terminating Date
A=Anniversary Date B=Month Start E=Next Month Start Default Value: A |
| 28 | FP_ACTN_STY_MGT | Character(1) | VARCHAR2(1) NOT NULL |
Action Authorization Managmnt
Y/N Table Edit Default Value: N |
| 29 | FP_COMM_ACCNT_MGT | Character(1) | VARCHAR2(1) NOT NULL |
CAE Control
Y/N Table Edit Default Value: N |
| 30 | FP_CM_ACNT_ID_LAST | Number(11,0) | DECIMAL(11) NOT NULL | Last CAE Number |
| 31 | FP_SAVE | Character(1) | VARCHAR2(1) NOT NULL |
Save Indicator
Y/N Table Edit Default Value: N |
| 32 | LAST_UPDATE_DATE | Date(10) | DATE |
Date of last update
Default Value: %date |