FPMPOINTYP_TBL(SQL Table) |
Index Back |
|---|---|
Types of Points TableFPS - Types of Points Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FP_POINTYP_CD |
Character(2) | VARCHAR2(2) NOT NULL | Point Type Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %Date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: %RECNAME_EDIT |
| 7 | 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: COMP_RATECD_TBL.COMP_FREQUENCY Prompt Table: FREQUENCY_TBL |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: COMP_RATECD_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 9 | FP_POINT_VAL | Number(12,4) | DECIMAL(11,4) NOT NULL | Point Value |
| 10 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL |
Standard Hours
Default Value: 169 |
| 11 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Standard Work Period
Default Value: M Prompt Table: STDHRS_FREQ_VW |
| 12 | FP_EXORDER_DT | Date(10) | DATE | Order Date |
| 13 | FP_APPL_DT | Date(10) | DATE | Application Date |
| 14 | LAST_UPDATE_DATE | Date(10) | DATE |
Date of last update
Default Value: %Date |