AR_SCR_ELEM_TBL(SQL Table) |
Index Back |
|---|---|
Risk Scoring ElementsRisk Scoring Elements. This table defines the delivered risk scoring elements. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RISK_SCORE_GRP |
Character(1) | VARCHAR2(1) NOT NULL |
Risk Scoring Group
2=System Defined History 3=User-defined History 4=Aging Information 5=Item Information 6=Customer Activity 7=Customer Table 8=Customer D&B Table |
| 2 | RISK_SCORE_ELEMENT |
Character(18) | VARCHAR2(18) NOT NULL | Risk Scoring Element |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | ALIAS_NAME_LONG | Character(30) | VARCHAR2(30) NOT NULL |
Alias Name
Prompt Table: AR_SQLFLD_VW |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | AR_FIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
AR field types
0=Character 2=Number 3=Signed Number 4=Date 6=Days 7=Percent 8=Decimal |
| 8 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 9 | AR_YES_NO | Character(1) | VARCHAR2(1) NOT NULL |
Yes or No Flag
N=No Y=Yes |
| 10 | AR_AMOUNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Amount
N=No Y=Yes |