OPERAND2AA=Auto Assigned (Lim/Unlim Vals)
CS=Custom Statement
DB=Data Base Field
DT=Date Field
DU=Duration (Age) Field
FR=Function Result
TL=Table Lookup
PA_CUSTOM1D_VW(SQL View) |
Index Back |
|---|---|
Stat Code view for operand1 |
| select alias_prompt, descr, alias_type from PS_PA_ALIAS_USE where alias_type not in ('FR','CS') or alias_name in (select b.functn_result_nm from ps_pa_fnc_rslt_tbl b where b.functn_name = 'SERVICE' or b.functn_name = 'VESTING' or b.functn_name = 'PLANELIG' or b.functn_name = 'PLANPARTIC') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPERAND2 |
Character(40) | VARCHAR2(40) NOT NULL | Operand2 |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | ALIAS_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Alias type
AA=Auto Assigned (Lim/Unlim Vals) CS=Custom Statement DB=Data Base Field DT=Date Field DU=Duration (Age) Field FR=Function Result TL=Table Lookup |