| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CLAIM_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Claim Number
Default Value: 0
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON_NAME
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
Prompt Table:
PER_ORG_ASGN_VW
|
| 4 |
NON_EMPLOYEE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Non-Employee ID
Prompt Table:
NE_INCIDNT_SRCH
|
| 5 |
CLAIM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Claim Status
A=Approved
D=Denied
P=Pending
W=Withdrawn
Default Value: P
|
| 6 |
OPEN_DT |
Date(10) |
DATE NOT NULL |
Created
Default Value: %date
|
| 7 |
REOPEN_DT |
Date(10) |
DATE |
Date Claim Re-Opened
|
| 8 |
CLOSE_DT |
Date(10) |
DATE |
Date Closed
|
| 9 |
INCIDENT_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table:
INJ_CLM_INCD_VW
|
| 10 |
INVESTIGATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Investigated
Y/N Table Edit
Default Value: N
|
| 11 |
CLAIMS_MANAGER |
Character(40) |
VARCHAR2(40) NOT NULL |
Claims Manager
|
| 12 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 13 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 14 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
PERSON_NAME
|
| 15 |
PROVIDER_CLAIM_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Provider Claim Nbr
|
| 16 |
PROVIDER_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Provider Description
|
| 17 |
ASSESSMENT_DT |
Date(10) |
DATE |
Assessment Date
|
| 18 |
CASE_DISPOSITION |
Character(2) |
VARCHAR2(2) NOT NULL |
Disposition
FR=Full return to work
LD=Long Term Disability
NF=Not fit to return at present
RR=Return with work restrictions
VR=Vocational rehabilitation
|
| 19 |
APPEAL_DT |
Date(10) |
DATE |
Date of Appeal
|
| 20 |
APPEALED_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Appealed By
1=Employer
2=Employee
3=N/A
Default Value: 3
|
| 21 |
CLAIM_NBR_CAN |
Number(8,0) |
INTEGER NOT NULL |
WCB Claim Number
|
| 22 |
CLM_CLAIMANT_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Claim Claimant
A=Beneficiary
C=CHSCT
E=Employer
S=Employee
|
| 23 |
CLM_RECIPIENT_FRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Claim Recipient
CP=CPAM
EM=Employer
TA=TASS
|
| 24 |
COMMENTS |
Long Character |
CLOB |
Comment
|