HRRFW_VARNAMECHAR=Character
DATE=Date
DTTM=Datetime
NUMR=Number
TIME=Time
C=Constant
D=Database Field
P=PeopleCode
S=System Computed
HR_RFW_VARAL_VW(SQL View) |
Index Back |
|---|---|
Variable ViewVariable View |
| SELECT HRRFW_VARNAME , HRRFW_DATATYPE , HRRFW_SYSVAR_SRC , DESCR FROM PS_HR_RFW_VARIABLE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRRFW_VARNAME |
Character(15) | VARCHAR2(15) NOT NULL | Variable Name |
| 2 | HRRFW_DATATYPE | Character(4) | VARCHAR2(4) NOT NULL |
Variable Type
CHAR=Character DATE=Date DTTM=Datetime NUMR=Number TIME=Time |
| 3 | HRRFW_SYSVAR_SRC | Character(1) | VARCHAR2(1) NOT NULL |
System Variable Source
C=Constant D=Database Field P=PeopleCode S=System Computed |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |