| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: SRVC_IND_SF_TBL.BUSINESS_UNIT
Prompt Table:
SP_BU_SF_NONVW
|
| 2 |
SRVC_IND_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Indicator Set
Default Value: SRVC_IND_SF_TBL.SRVC_IND_SET
Prompt Table:
SRVC_IND_SF_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: SRVC_IND_SF_TBL.EFFDT
|
| 4 |
SF_SEVERITY |
Number(3,0) |
SMALLINT NOT NULL |
Severity
|
| 5 |
AGING_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Aging Set
Prompt Table:
AGING_TBL
|
| 6 |
ACCOUNT_TYPE_SF |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Type
Prompt Table:
ACCT_TYP_TBL_SF
|
| 7 |
SRVC_IND_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Indicator Cd
Prompt Table:
SRVC_IND_CD_TBL
|
| 8 |
SRVC_IND_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Indicator Reason
Default Value: SRVC_IND_CD_TBL.DFLT_SRVC_IND_RSN
Prompt Table:
SRVC_IN_RSN_TBL
|
| 9 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Default Value: SRVC_IN_RSN_TBL.DEPTID
Prompt Table:
DEPT_TBL_ACCESS
|
| 10 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
PEOPLE_SRCH
|
| 11 |
MINIMUM_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Mininum Transaction Amount
|
| 12 |
AGE_CATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Aging Category
Prompt Table:
AGING_CAT_SF_VW
|
| 13 |
USE_RECORDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Records
Y/N Table Edit
Default Value: Y
|
| 14 |
USE_ADMISSIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Admissions
Y/N Table Edit
Default Value: Y
|
| 15 |
USE_ORG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Organization
Y/N Table Edit
Default Value: N
|
| 16 |
NO_CAREER |
Character(1) |
VARCHAR2(1) NOT NULL |
No Career Flag
Y/N Table Edit
Default Value: N
|